Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
when you open the sheet, you have auto date set... therefore it asks you to
save changes because the date changed from when you last opened it... so in fact, you did change something by simply opening the sheet... ciao! "Menno Hershberger" wrote: This has been bugging me for about three years now, so I thought I'd see if there was a solution. I run a computer shop. I do all my invoices in Excel and keep them all in one folder. Sometimes I want to go back and look at a customer's invoice from the past to familiarize myself with what previous repairs, upgrades, or whatever that I did before. I sort the folder by date. Whenever I open the invoice to just look at it and go to close it again it always asks me if I want to save my changes. I didn't MAKE any changes! Once in a while, not thinking, I'll click Yes and then I wind up with a new time stamp on the file, which of course puts it out of order. The only way I can get it right again is to change my computer date back to the original date and save it yet again. Right now I'm running Office XP-SP2 but it did it in previous versions of Office also. Why does it do this and is there any way I can stop it? Thanks. -- --- A Freudian slip is when you say one thing but mean your mother. --- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |