On Exit, always asked to save

  • Thread starter Thread starter loveexcel
  • Start date Start date
L

loveexcel

I have a worksheet that whenever I open it to view only, I am asked if
I want to save when I exit the file. I am not making any changes. Is
there a way to find the field that is updating automatically? I'm
assuming there must be a field like: ()now that is automatically
changing and this is why Excel then asks if I want to save my changes.
But like I said, I am not making any changes.

Thanks for your help!
 
There are several Volatile Functions.

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

Any one or more of these could be the culprit.

You can do a Find for these or hit CTRL + `(backquote above Tab key) to toggle
View Formulas on and do a look search by eyeball.


Gord Dibben MS Excel MVP
 
Thanks! Found the culprit!


Gord said:
There are several Volatile Functions.

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

Any one or more of these could be the culprit.

You can do a Find for these or hit CTRL + `(backquote above Tab key) to toggle
View Formulas on and do a look search by eyeball.


Gord Dibben MS Excel MVP
Click to expand...
 
You must log in or register to reply here.

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

Close all without saving and exit without prompts 8
Worksheets with OFFSET command always ask if I want to SAVE 2
Execel file auto save 1
Saving Prompts 2
Need VB formula to exit workbook 1
Save As Macro 2
Why do certain worksheets ALWAYS ask if I want to save them when closing them? 5
save and exit macro 8

Back
Top