Ask a new question

How to Auto Update Linked Charts in Word 2013 When Document Opens

Does anyone know how to have charts, that were pasted & linked from Excel 2013 to Word 2013, automatically update when the Word document is opened? I have the "Update Automatic Links at Open" selected in the Word, but to update the charts I have to select each one and "refresh", which is a pain with lots of charts.

Would VBA work?

Using Windows 8.1

Thanks!

DNA
Answer
Answer

If you use CTRL+a and then press F9, are the charts updated?

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

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.

 
 

Question Info

Last updated November 28, 2022 Views 5,829 Applies to: