On Mon, 18 Jul 2005 14:01:34 -0700, 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.

Sounds like you have something in it that recalculates when you open
the document. You can set it to not recalculate:

Tools -- Options -- Calculation -- Manual

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner