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