paste special

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Paste Special

Paste Special

resolvedResolved · Low Priority · Version 2016

Penny has attended:
Excel Advanced course
Excel Advanced course

Paste Special

When trying to paste a link to Excel, the whole table didn't come through, just an enlarged part of the table.


RE: Paste Special

Hello Penny,

Thank you for your question. What works for me when I paste Excel data into PowerPoint, is to select the entire table in Excel, then switch to PowerPoint, select Paste - Paste Special - Paste Link - Microsoft Excel Worksheet Object. I get the entire table into PowerPoint when I do this, even with a large table.

You can also right-click inside the slide in PowerPoint, then use one of the paste icons. Two of these icons paste with a link to Excel.

If this still doesn't work for you, please let us know, so that we can try a different method.

Kind regards
Marius Barnard
STL

RE: Paste Special

Hi Marius,

Thank you for your answer. Unfortunately, I was trying to paste using the first option you gave in your answer. I was in a training course with your colleague Dennis, and he couldn't work out why select Paste - Paste Special - Paste Link - Microsoft Excel Worksheet Object didn't work.

Kind regards

Penny

RE: Paste Special

Hi Penny,

The only time I only get part of a table is when I do it from inside PowerPoint (Insert - Object - Create from File - Browse - select file - OK).

Otherwise I always get the entire table when I start from Excel. If you are still having trouble, I could ask my fellow trainers if they have come across the issue.

Kind regards
Marius

RE: Paste Special

Hi everyone,

This is Claire, watching the forum on Friday 6th.

I'm sure you've checked this but I can't see it mentioned in your thread: have you saved the PowerPoint you're pasting into?

If you haven't yet saved the presentation you can get some strange results when doing paste link.

Does that help?

thanks
Claire

Fri 13 Sep 2019: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

PowerPoint tip:

Drawing lines in slide show

To draw straight lines in your slide show presentation, either horizontal and vertical lines, hold down the shift key and with the Mouse / pen highlighter, drag.

View all PowerPoint hints and tips


Server loaded in 0.1 secs.