View Single Post
  #10   Report Post  
Menno Hershberger
 
Posts: n/a
Default

Wish it was that simple, but no, it doesn't auto date.

Bigtalker wrote in
:

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




--
--- A Freudian slip is when you say one thing but mean your mother. ---