View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default save changes when no changes made

Elaine

There are a few other volatile functions that would cause this.

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

Dave is probably correct with the older version.newer version guess.


Gord Dibben MS Excel MVP

On Wed, 18 Jan 2006 10:17:02 -0800, Elaine
wrote:

When I go to close an Excel document, I am asked about saving changes even
though none have been made. I have already searched this question here and
every suggestion has not helped. I do not have any macros in the workbook,
no links to any other workbooks and it does not have any functions that may
cause this (I know that TODAY(), NOW(), etc.) can cause this.

Any suggestions to find what I have stuck in the file or a setting wrong? I
have Excel 2002