I have a relatively small spreadsheet containing a number of simple formulas
(i.e. A2-B2; Sum(C2:C15), etc). When ever I enter data in a cell, the
spreadsheet appears to be refreshing the data in in EVERY cell, whether it
was affected by the input or not. As a result, it takes an unreasonable
amount of time to do updates.

I have numerous other workbooks with significantyly larger amounts of data
and multiple complex formulas and functions which do not have the same
problem when I use them.

Anyone run across this before? Any suggestions?

It could be you are using volatile functions, or any of several items that
force cell recalculation. Check
http://www.decisionmodels.com/calcsecretsi.htm. Good luck!

"Steve 51" wrote:

I have a relatively small spreadsheet containing a number of simple formulas
(i.e. A2-B2; Sum(C2:C15), etc). When ever I enter data in a cell, the
spreadsheet appears to be refreshing the data in in EVERY cell, whether it
was affected by the input or not. As a result, it takes an unreasonable
amount of time to do updates.

I have numerous other workbooks with significantyly larger amounts of data
and multiple complex formulas and functions which do not have the same
problem when I use them.

Anyone run across this before? Any suggestions?

On Oct 18, 11:38 am, Steve 51
wrote:
I have a relatively small spreadsheet containing a number of simple formulas
(i.e. A2-B2; Sum(C2:C15), etc). When ever I enter data in a cell, the
spreadsheet appears to be refreshing the data in in EVERY cell, whether it
was affected by the input or not. As a result, it takes an unreasonable
amount of time to do updates.

I have numerous other workbooks with significantyly larger amounts of data
and multiple complex formulas and functions which do not have the same
problem when I use them.

Anyone run across this before? Any suggestions?

ToolOptionCalculation
Select Manual instead of automatic.
This might help.

Faruk Gashi