Excel closing

  • Thread starter Thread starter Mayoone
  • Start date Start date
M

Mayoone

Why does Excel ask "Do you want to save the changes you
made to ...?" when I didn't make any changes? Can this
be disabled?
 
Do you have =TODAY() or =NOW() in the file? If you do, the value will change
on opening, hence the message.
 
Here's a list of volatile functions

AREAS()
CELL()
COLUMNS()
INDIRECT()
INDEX()
NOW()
OFFSET()
RAND()
ROWS()
TODAY()
 
Thanks Peo, Is that all of them
Alan.
Peo Sjoblom said:
Here's a list of volatile functions

AREAS()
CELL()
COLUMNS()
INDIRECT()
INDEX()
NOW()
OFFSET()
RAND()
ROWS()
TODAY()

--

Regards,

Peo Sjoblom
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

xls:1 but no xls:2 1
Why does Excel ask to save when no changes were made? 4
Closing Excel without alert 5
Why does Excel ask to Save on Exit? 6
Problem opening an Excel file 1
Keeps asking to save. 2
How can you turn off "Do you want to save changes you made to ..." 2
Why doesn't Excel understand what 'Manual' for Calculations? 4

Back
Top