HELP! optimize calculating values
 

Hello,

I have a complex Excel file that have several sheets with calculated formula
and conditional formatting, etc... The raw data came from importing data from
an Access file, then several columns with calculated data. Everytime I change
a value in any rows, it takes forever to recalculate the values in the
formulas, even just changing one value in the row.
Is there an option in Excel that allow me to change all the necessary data,
then update the formulas after all the changes, not update every once change?
Thanks

HELP! optimize calculating values
 

You can change the default from automatic to manual calculation.
Tools - Options - Calculation - Manual
You they use F9 to recalculate.

The reason that you have this problem is that you have surpassed the smart
calc limit in XL. Check out this link for more info...
http://www.decisionmodels.com/calcsecrets.htm
--
HTH...

Jim Thomlinson


"Cam" wrote:

Hello,

I have a complex Excel file that have several sheets with calculated formula
and conditional formatting, etc... The raw data came from importing data from
an Access file, then several columns with calculated data. Everytime I change
a value in any rows, it takes forever to recalculate the values in the
formulas, even just changing one value in the row.
Is there an option in Excel that allow me to change all the necessary data,
then update the formulas after all the changes, not update every once change?
Thanks

HELP! optimize calculating values
 

You can change from Automatic to Manual recalculation by clicking on
Tools | Options | Calculation tab. Then you can make your changes and
press F9 when you want a full recalculation. The file is usually
recalculated immediately before a Save operation, but this is another
option you can change on that tab. Note that any other files that you
open while in that same session with Excel will also inherit the
Manual calculation mode.

Hope this helps.

Pete

On Apr 15, 4:59*pm, Cam wrote:
Hello,

I have a complex Excel file that have several sheets with calculated formula
and conditional formatting, etc... The raw data came from importing data from
an Access file, then several columns with calculated data. Everytime I change
a value in any rows, it takes forever to recalculate the values in the
formulas, even just changing one value in the row.
Is there an option in Excel that allow me to change all the necessary data,
then update the formulas after all the changes, not update every once change?
Thanks

HELP! optimize calculating values
 

Jim

I was wondering why the option went back to automatic update after I save
the document, exit and reopen the file after I changed to Manual updating?
Thanks

"Jim Thomlinson" wrote:

You can change the default from automatic to manual calculation.
Tools - Options - Calculation - Manual
You they use F9 to recalculate.

The reason that you have this problem is that you have surpassed the smart
calc limit in XL. Check out this link for more info...
http://www.decisionmodels.com/calcsecrets.htm
--
HTH...

Jim Thomlinson


"Cam" wrote:

Hello,

I have a complex Excel file that have several sheets with calculated formula
and conditional formatting, etc... The raw data came from importing data from
an Access file, then several columns with calculated data. Everytime I change
a value in any rows, it takes forever to recalculate the values in the
formulas, even just changing one value in the row.
Is there an option in Excel that allow me to change all the necessary data,
then update the formulas after all the changes, not update every once change?
Thanks