Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Possibly
Application.CalculateFullRebuild or Application.CalculateFull Your a little vauge about what triggers your macros. If it is a workbook_activate event then You might need to do for each bk in Workbooks if lcase(bk.Name) < "summary.xls" then bk.Activate Activesheet.Range("A1").Select end if next workbooks("Summary.xls").Select -- regards, Tom Ogilvy "Fred Ernst" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculations from tab to tab not automatically updating | Excel Worksheet Functions | |||
Why not automatically updating calculations? | Excel Discussion (Misc queries) | |||
Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) | |||
Updating calculations + graph when i enter in new data WITHOUT OFF | Excel Worksheet Functions | |||
updating links with calculations in many workbooks | Excel Programming |