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
 

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

Similar Threads

Excel Unlink open excel files 2
How to stop: Save Notebook, when I only moved the cursor? 1
How to turn off "Backup of" .. xlk files ? 1
Oversensitive touchpad on modern laptops 0
Excel Move or Copy Stopped Working? 0
Excel 2007 acting weird 8
Excel 2007 Suppress "bell ringing" when switching windows?? 3
Excel 2007 - How to stop Backup of...xlk files from xlsm files? 3

Back
Top