View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Updating Calculations

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