Auto-updating Linked data between excel and powerpoint

Hi,

 

I am able to link an excel graph to powerpoint using copy and paste+special. When I do this, the graph I copied automatically updates to corresponding changes made in excel. However, when I save both files and exit them, the link breaks? After re-opening both files, the update feature doesn't work properly. I have to manually update the link by right clicking the graph (in the powerpoint slide) and selecting update link.

 

Is there a way to automatically update the linked data between excel and powerpoint without having to do it manually?

Will the update work when powerpoint is in presentation mode?

Hello Aaron,

Thank you for choosing Microsoft Office Community.

Let's try the following and verify the result;

1) Create a chart in Excel and copy it.
2) Use Paste Special option and paste the copied chart into PowerPoint with data link.
3) Click on File > Info > select Automatic for Update option > Close.
4) Now save the PowerPoint and Excel files and close them.
5) Re-open Excel file, make any changes and save it.
6) Re-open PowerPoint presentation and check if you're prompted to update links.

Hope the above information helps. Reply with the result and I'll be glad to further assist you.

Thank You.

42 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hello Dan,

 

Thank you for your response, as it did help.

 

I am curious to see if it is possible to have the presentation run on a loop and have the graphs update when the excel data changes. The powerpoint would be open on one computer while the excel file is on another. The two files will be in a shared folder between the computers.

 

Can the update occur when the slide is in presentation? Can it be automatic with changing information on the excel file?

14 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Can anyone help me with these questions?

 

"Can the update occur when the slide is in presentation? Can it be automatic with changing information on the excel file?"

 

I would like an answer.

4 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hello Aaron,

I apologize for the delayed response.

It is not possible to simultaneously view the updated changes when PowerPoint presentation is already running.

Hope the above information helps. Feel free to reply if need any assistance and I'll be happy to help you.

Thank You.

18 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 24, 2024 Views 108,609 Applies to: