View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred Ernst[_2_] Fred Ernst[_2_] is offline
external usenet poster
 
Posts: 6
Default Updating Calculations

I'm using a Workbook that has macros in it for updating Charts when input
and calculations change. I do not have access to the code for the Workbook.

I have multiple instances with different filenames of this Workbook open in
tile mode, with links in both directions to another "Summary" Workbook.

The instances of the Workbook with the Chart macros won't update until I
click individually on them. So I need to click on each one of them to update
the "Summary" Workbook properly.

Is there a procedure I can use to recalculate all of the instances of the
Workbooks with the Chart macros at the same time?

Thanks,
Fred