I suspect that you use =TODAY() or =NOW() in one of the cells in your
spreadsheet to automatically input the date when you produce the Invoice.

When you subsequently open the Invoice, Excel will update the date ... hence
asking you if you want to save changes.

I would suggest that before you "finalise" the Invoice, you copy the date
(or all the data) and Paste Special | Values to save the current value(s).
The Invoice will then never change. Problem solved ;-)

Regards

Trevor


"Menno Hershberger" wrote in message
...
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. ---