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

That sounds like it might be the problem. How do I know if I am using an old
version of Book.xlt and if I am how do I change it to an up to date version?

"Dave Peterson" wrote:

Have you recently upgraded to a new version of excel?

If yes, are you still using the old version of book.xlt in XLStart?



Iain A C T wrote:

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


--

Dave Peterson