View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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