Updating links of all charts in WB

[Debo333]

Hi there,

I currently have a workbook with about 50 charts spread over 15ish sheets with links to 4 different excel spreadsheets. I am trying to build a macro that will update all links for eac chart in the workbook. I found code from MSN help for updating a ppt slide with excel linked charts, but not an excel file and was unable to manipulate it to work for me.

I know i can do this each time I open the workbook, but the workbook is intended to be open 24/7 with about a 100 user form inputs throughout the day.

Let me know if anyone can help, and thank you for your time.

 

[GlennUK]

If you do Edit/Links you can Update the links while the workbook is open without having to close and re-open it. You can even put this operation in a macro.