View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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