Keep Source Formatting & Link Data

Question

Hi,

we are linking data from Excel into PowerPoint. We have already formated the date in Excel.

When we link the data into PowerPoint we get changes in the row height, font size etc. although all these formatting is the same in Excel. The only difference is that in one worksheet the data is in more columns and rows than on the other worksheet but surely that should not mess up the formating.

I am missing the option "Keep Source Formatting & Link Data" Option. Our smarttag won´t suggest that so we go via Home - Paste Special....

However, we noticed the following: When copying the first table, we see "Attach Hyperlink" in the "Paste Special" dialog box. When we try to link the second table, which is displayed right next to the first table on the same sheet "Attach Hyperlink" is not showing. We can´t figure out what´s different between those two tables.

Any ideas how we can ensure that our Excel data stays as it is when linking it into PowerPoint?

Kind regards.

Nicole

Answer 1

Hi Daniel,

Many thanks for your reply and sorry for my late response. We are still investigating but my suspicion is, that the file may be corrupt. Didn´t have a chance yet to test on the PC in question but it did work with a new worksheet on my PC so my guess is that there is something wrong with the file.

Regards,

Nicole

Answer 2

Hello Nicole,

Thank you for choosing Microsoft Community and thanks for posting the question.

I will assist you with the formatting and linking issue you’re experiencing in PowerPoint.

Please provide additional information for better assistance:

1. How are you linking multiple worksheets into PowerPoint?
2. Do you have Skype installed on your computer?
3. Do you have the option ‘Use smart cut and paste’ and ‘**Show Paste Options button when content is pasted’**checked under File > Options > Advanced > ‘Cut, copy and paste’ checked? If no, check the option and save it settings and try linking the table and verify the result.

Create a new worksheet with tables and try linking it in PowerPoint and verify whether issue re-occurs.

The ‘Attach hyperlink’ option won’t appear for the second table copied from a same worksheet as the first table would already establish the link to the worksheet.

I hope the above information is helpful. Reply with necessary information and the result for further assistance.

Thank You.