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.
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.