Use Tools | Options and open Calculation tab
Check the Manual box
To get worksheet to calculate, press F9
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Rich D" wrote in message
...
I have a workbook with several worksheets that involve a lot of conditional
summing. everytime I make an entry, I have to wait for it to do it's
calculations. I'm sure there's a way to tell it to not make any
calculations
until I tell it or until I leave/save the file. You guys have been great
so
far. Can you help me here? Thanks.
--
Rich D
Armstrong Custom Homes
Redmond