How do I STOP this;;;;;

  • Thread starter Thread starter J
  • Start date Start date
J

J

Excel 2007

How do I stop Excel from asking me to save changes when only the cursor has
been moved?

Previous versions did not do this. It is quite annoying.

J
 
Does your file contain formulas that use any volatile functions?

NOW

TODAY

RAND

RANDBETWEEN

OFFSET

INDIRECT

INFO

CELL

INDEX (although this function *is not volatile* certain formulas that use it
that are crafted in a certain way will appear to be volatile when the file
first opens)

When you open a file it calculates and if you use any of the above functions
(INDEX in rare situations) Excel will register a change and that's why you
get the message when you try to close the file.
 
In addition to biff great answer (and these function effected all previous
version) you should know that when Excel encounters a file from an earlier
version it always assumes a save is needed - it has ever been thus
 
Back
Top