Calculation

  • Thread starter Thread starter m
  • Start date Start date
M

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 *****
 
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
 
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
 
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
 
Back
Top