Initial Formula Calculation

J

jestersdead

Hi All,

I'm trying to find a away to turn off calculation in Excel.

I know how to stop recalculation (Tools > Options > Calculations
etc, but I want to be able to type in a formula, or rather have a macr
create many formulas, and not have the formula(s) calculate until
choose.

Any ideas
 
C

Charles Williams

Excel always evaluates each formula as it is entered, even in manual
calculation mode, except when you drag-copy a formula from a cell to a
number of other cells.
The only other alternative is to enter the formula as a string with
something like # instead of = on the front, and then do a search/replace of
# with = when you want the formulae calculated.

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"jestersdead" <[email protected]>
wrote in message
news:[email protected]...
 
J

jestersdead

Thanks Charles, I thought I might have to do that, was hoping there was
a more elegant way though.
 
Top