Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking 3 levels
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking 3 levels
"steve" wrote...
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking 3 levels
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking 3 levels
"steve klein" wrote...
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotal levels | Excel Discussion (Misc queries) | |||
sum sub levels. | Excel Discussion (Misc queries) | |||
sum sub levels. | Excel Worksheet Functions | |||
sum sub levels. | New Users to Excel | |||
VLOOKUP with more than 7 levels of IF | Excel Worksheet Functions |