Saving Document in Excel
Sam
There are several Volatile Functions.
AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()
Any one or more of these would cause the workbook changes.
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.
Gord Dibben MS Excel MVP
On Tue, 11 Jul 2006 07:10:02 -0700, Sam wrote:
Why does excel ask if i want to save a document when i have made no changes?
it happens only with certain workbooks, not all of them. Do I need to change
my settings?
Gord Dibben MS Excel MVP
|