linking 3 levels

[steve]

I am trying to link three levels of workbooks without having to open
all of the intermediate workbooks.

Example: If I enter a number in first level I would like the next set
of workbooks (141) to calculate automatically. The third level would
then reflect the results of the calculations without having to update
all of the workbooks (141). Is there a simple way of doing this or do
I have to activate 141 workbooks?

Thanks,
Steve

 

[Harlan Grove]

I am trying to link three levels of workbooks without having to open
all of the intermediate workbooks.

Example: If I enter a number in first level I would like the next set
of workbooks (141) to calculate automatically. The third level would
then reflect the results of the calculations without having to update
all of the workbooks (141). Is there a simple way of doing this or do
I have to activate 141 workbooks?

If the level 2/intermediate workbooks aren't open, how do you believe they
could recalculate in response to an entry in the level 1 workbook?

You have to open workbooks to have them recalculate.

 

[steve klein]

Harlan,
I realize that I have to update the intermediate files. I was trying to
establish the best way to do it. Whether I can simply open and close all
the files without the necessary prompts and the screen flashing.

Steve

 

[Harlan Grove]

I realize that I have to update the intermediate files. I was trying to
establish the best way to do it. Whether I can simply open and close all
the files without the necessary prompts and the screen flashing.

You should be able to. Bracket your code between

Application.EnableEvents = False
Application.ScreenUpdating = False
Application.DisplayAlerts = False

....

Application.EnableEvents = True
Application.ScreenUpdating = True
Application.DisplayAlerts = True