Hi all,
I'm new to this so please forgive me if I haven't named this thread correctly or if it is in the wrong place. OR if this questions has been answered before (I did try to google it).
My question revolves around calculation dependency of linked workbooks, an example is probably the best way to ask my question:
I have two workbooks WB1 and WB2. Automatic update of links is off and manual calculation is on.
WB1 has a sheet with lots of data that changes from time to time.
WB2 has the same sheet except the data is pulled from WB1 using direct links (e.g. =['WB1.xlsb]Sheet1'!A1), there may be thousands of these "direct" links.
WB2 also has another sheet that does a bunch of heavy calculations based on the data that is being pulled through these direct links.
If I open WB1 and then open WB2, the direct links want to update to make sure they are correct (and therefore the option to calculate will appear down the bottom left).
My question is, once the direct links between WB1 and WB2 have been updated (calculated), if the values don't change (i.e the data was up-to-date and correct) will excel still go ahead and calculate the other sheet with all the heavy calculations? Or, does it realize that the data being pulled from WB1 hasn't changed and therefore it knows it doesn't need to calculate the formulas based on this data?
I hope that all makes sense. If this question is answered elsewhere please feel free to post a link.
Thanks in advance.
lazz64
Bookmarks