How do I turn off the "do you want to save" alert in excel?

G

Guest

I use Excel extensively and would like to turn off the alert that asks me to
save every time I attempt to close a workbook. 99% of the time, I am not
making changes to the data, simply viewing. Any hints?
 
G

Gord Dibben

SLB

Perhaps you have one or more volatile functions
in your workbook.

There are several Volatile Functions.

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

Any one or more of these could be the culprit that is updating and causing the
change(s) to be made.

You can do a Find for these or hit CTRL + `(backquote above Tab key) to toggle
View Formulas on and do a look search by eyeball.

Also, if the workbook you are opening was created in an older version of Excel,
you will be prompted to save.

If you do save, you won't be prompted again.


Gord Dibben MS Excel MVP


On Tue, 29 Aug 2006 14:17:01 -0700, SLB, accounting <SLB,
I use Excel extensively and would like to turn off the alert that asks me to
save every time I attempt to close a workbook. 99% of the time, I am not
making changes to the data, simply viewing. Any hints?
Click to expand...

Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turn off Excel alert 1
How can you turn off "Do you want to save changes you made to ..." 2
File close excel does not ask me to save changes 2
Personal Macro 1
Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file 4
background commands running in Excel? 1
Turn display alerts off then back on at close 1
Closing Excel without alert 5

Top