Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / November 2003

Tip: Looking for answers? Try searching our database.

When closing file, asks to save changes when there are none

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed - 25 Nov 2003 15:46 GMT
When I close an Excel 2000 file, I always get the dialogue box that asks if I want to save changes even though I have made no changes.  Appears to be happening to only one of my Excel files but not all.  I'm guessing I have a bad setting in that one file

Thanks for the help.
Graham - 29 Nov 2003 00:00 GMT
I am guessing that somewhere in the excel file there is a
formula using a date (Today(), Month, etc etc)
In which case this behaviour is normal as it changes each
time the sheet is opened...
Graham
>-----Original Message-----
>When I close an Excel 2000 file, I always get the dialogue box that asks if I want to save changes even
though I have made no changes.  Appears to be happening
to only one of my Excel files but not all.  I'm guessing
I have a bad setting in that one file.

>Thanks for the help.
>.
Ed - 29 Nov 2003 04:41 GMT
Ah Graham, you are very perceptive.  It was not a time or date formula, but instead I was using a RANK function in one of my worksheets.  Every time I opened that workbook, it performed the RANK function thereby constituting a change to the file and prompting the dialogue box in my original question.  I isolated by copying one worksheet at a time to a new file until I found which worksheet it was.  Then I employed your theory and isolated it down to that stinking RANK function.  You were clearly on the right track with your solution and I want to extend a million thank yous for your idea that led to the solution.  Now I can sleep peacefully now that my Excel file works the way I want it to (yes, I need to get a life).  I wonder if any/all functions have the same affect??

Thanks a million, Graham!

ED
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.