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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rob - 26 Aug 2006 11:15 GMT

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?

Signature

robuk2005

Reply to this Message

Paul B - 26 Aug 2006 13:51 GMT

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

Signature

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

> 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?

Reply to this Message