Calculation

[m]

Hi
I have one "big" excel file with lots of data and formulas. It takes
about 1 minute to calculate everything once data is changed.
If i open new excel file and put anything in it that "big" file is being
recalculated. why? can this be changed?
thanks.
m.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Frank Kabel]

Hi
you may set the calculation mode for your 'big' file to 'Manual' (goto
'Tools- Options - Calculation').
This way you have to hit F9 to re-calculate this workbook

 

[Frank Kabel]

Hi
you may set the calculation mode for your 'big' file to 'Manual' (goto
'Tools- Options - Calculation').
This way you have to hit F9 to re-calculate this workbook

 

[Niek Otten]

The calculation mode is Excel-wide. It is determined by the first opened
workbook, or by manual alteration afterwards. But you can't have two books
open of which only one calculates automatically.

Probably some formula in the large workbook is volatile; maybe NOW(),
TODAY(), or random number generators. Or there are volatile UDFs.

In general, for performance issues, visit

www.decisionmodels.com

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel