98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Paste Special
Paste Special
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
PowerPoint tip:Drawing lines in slide showTo 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. |