Forced to save - even if no changes

R

RJB

I have one file that when I close it, it always asks me if I want to save
changes, even if I didn't even breathe while it was open. What gives?
 
M

Max

RJB said:
I have one file that when I close it, it always asks me if I want to save
changes, even if I didn't even breathe while it was open. What gives?
Click to expand...

One reason is that your file probably contains volatile functions, eg: OFFSET

---
 
G

Gord Dibben

If the workbook you opened was created in an earlier version of Excel you will
get the "save changes" message.

Save as your current version.

You will also get the message if you have used any volatile function(s) in your
workbook.

Could be a NOW() or TODAY()

List of volatile functions........

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

Any one or more of these would cause the workbook changes.


Gord Dibben MS Excel MVP
 

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

Save changes? even when you've made none 3
Why does Excel ask to Save on Exit? 6
Turning off prompt to save file with no changes 5
Excel prompts to save when no changes made 2
Why does Excel ask to save when no changes were made? 4
Why do certain worksheets ALWAYS ask if I want to save them when closing them? 5
background commands running in Excel? 1
xls:1 but no xls:2 1

Top