How do I STOP this;;;;;

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
 
T

T. Valko

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top