Link to home
Create AccountLog in
Avatar of agwalsh
agwalsh

asked on

Linked Pivot table not updating in PowerPoint presentation when changes are made.

I am currently using PowerPoint 365 with Excel 365 and in earlier versions of Excel/Powerpoint if I updated a pivot chart in Excel then that was reflected in my PowerPoint (I was using Paste : Use Destination Theme and Link Data - however I'm finding that even when I refresh the data in PowerPoint, the changes are not always reflected...why is that?

Secondly, where can I find an explanation of the difference between Link Data and Embed workbook - and when would you use one over the other?
ASKER CERTIFIED SOLUTION
Avatar of Jamie Garroch (MVP)
Jamie Garroch (MVP)
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of agwalsh
agwalsh

ASKER

Thank you so much. That really does clarify the issue. Any ideas why a linked or embedded file wouldn't update in the PowerPoint presentation when data is changed. It used to work fine in earlier versions...

Thanks
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Avatar of agwalsh

ASKER

Thank you so much ..clarified this issue for me :-)
You're more than welcome agwalsh. Glad I could help you out and it was fun exploring the behaviour and solution!