Why am I prompted to save changes I haven't made in Excel 2002?

G

Guest

When I try to close an Excel document I have opened, I am consistently asked
by Excel "Do I wish to save the changes I have made" when I haven't knowingly
made any changes. Can anybody tell me why this is happening and how to stop
it please?
 
P

Paul B

rob, Some functions in excel are "volatile", they will re-calculate every
time excel is opened, this will make the worksheet change even if you don't
make any changes.

Have a look here for a list and more information about it

http://www.decisionmodels.com/calcsecretsi.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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

Why does Excel spreadsheet lose format changes after saved? 1
How do I stop excel from asking me if I want to save my document? 3
Excel prompts to save when no changes made 2
Why does Excel ask to save when no changes were made? 4
changing default format with personal.xls 5
"Do you want to save changes" not working... 1
Why does Word ask to save changes when I haven't made any to the 2
Do you want to save changes to ..... 3

Top