how do I stop excel from recalculating sheet every time I open one
 

Every time I open a spreadsheet it recalculates formulas so that means even
if I open one up to look at I now cant just x it out i have to say save, dont
save etc - another annoying step when I am in a hurry

how do I stop excel from recalculating sheet every time I open one
 

EXCEL 2007

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Formulas (on the left hand side) then, on the right hand side, in:-

Calculation options

- switch the Workbook Calculation to Manual then hit OK.

If my comments have helped please hit Yes.

Thanks.

Formulas (on left hand side) / then, on the



"seeing green" wrote:

Every time I open a spreadsheet it recalculates formulas so that means even
if I open one up to look at I now cant just x it out i have to say save, dont
save etc - another annoying step when I am in a hurry

how do I stop excel from recalculating sheet every time I open one
 

Hi,

If Excel is prompting for a 'save' then something has changed. For example
this could be a cell with a formula in that looks at the current time.

If you haven't changed anything else then it's probably safe to ignore this
and simply close without saving but I wouldn't do it and if you want to know
why then this forum has posts from people asking how they can get their data
back because they forgot to save.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"seeing green" wrote:

Every time I open a spreadsheet it recalculates formulas so that means even
if I open one up to look at I now cant just x it out i have to say save, dont
save etc - another annoying step when I am in a hurry

how do I stop excel from recalculating sheet every time I openone
 

On 4/29/2010 6:34 AM, seeing green wrote:
Every time I open a spreadsheet it recalculates formulas so that means even
if I open one up to look at I now cant just x it out i have to say save, dont
save etc - another annoying step when I am in a hurry

trip_to_tokyo has the right idea, but be careful. People tend to make
mistakes when they are in a hurry...

Bill