View Single Post
  #3   Report Post  
Iain A C T
 
Posts: n/a
Default

Thanks for the reply but it has nothing to do with formulas or earlier
versions of Excel, even if you open a new workbook and then just close it, it
still ask me if I want to save the changes.

"Dave Peterson" wrote:

Do you have any of these volatile functions in your workbook?

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

These evaluate with each calculation. And cause excel to think your workbook
has changed.

And excel likes to recalculate workbooks created in earlier versions. Is this
the case in your situation?

Iain A C T wrote:

When I open a blank workbook and the go to close it again without having done
any work on it Excel asks me if I want to save the changes. How can I stop it
from doing this? It is getting annoying everytime I just want to look at a
workbook being asked if I want to save the changes.


--

Dave Peterson