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


"Carl" wrote in message ...
|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.