Is it necessary to use CalculateFull command when in automatic mod

[Guest]

I have a very large workbook that takes about 4 minutes to update external
links. When I want to update links I am not sure whether it would be better
to just place the calculation mode in automatic and change a cell to trigger
Excel to calculate all cells or whether to just leave in manual and run the
command "CalculateFull". I have had some problems leaving it in manual and
running CalculateFull but am not certain it will update the links if I just
place it in automatic. I am concerned however that if I put it in automatic
AND run the CalculateFull command I may be just doubling the refresh time.
Thanks in advance.

 

[Niek Otten]

Hi Carl,

You shouldn't even need CalculateFull; Calculate (F9) should do.
If you are afraid that not all cells and links are updated, rebuild Excel's dependency tree once with CalculateFullRebuild
(CTRL+ALT+SHIFT+F9).
Look here for many tips about calculation:

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I have a very large workbook that takes about 4 minutes to update external
| links. When I want to update links I am not sure whether it would be better
| to just place the calculation mode in automatic and change a cell to trigger
| Excel to calculate all cells or whether to just leave in manual and run the
| command "CalculateFull". I have had some problems leaving it in manual and
| running CalculateFull but am not certain it will update the links if I just
| place it in automatic. I am concerned however that if I put it in automatic
| AND run the CalculateFull command I may be just doubling the refresh time.
| Thanks in advance.

 

[Guest]

Thanks so much, Niek. I will check the link you sent. I still wonder if when
I put the calculation mode in automatic and Excel recalculates all links (4
minutes), will it calculate them all again (another 4 minutes) if I press F9?
I can't just leave it in automatic all the time because it tries to update
the links everytime someone makes a change on the worksheet. Thanks again.