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

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

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

You can bypass this by setting the workbooks Saved property to True during
the close event. Let me know if you need to know where to put the code.

Private Sub Workbook_BeforeClose(Cancel As Boolean)

If Sheets(1).Range("A1") = "Y" Then

ActiveWorkbook.Saved = True

End If

End Sub


You would need to have an indicator as to whether the invoice is complete or
not. In this example, if Cell A1 in Sheet 1 is not equal to Y then you will
get the save prompt. If Cell A1 contains the letter Y, the workbook will
close without saving.

HTH,

Matt





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

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

Another option, is to look at the file list in Date Created order --

In Excel, choose FileOpen
Right-click on an empty part of the window, and choose ViewDetails
Right-click on the column headings, e.g. Name, Date Modified
Select Date Created
Click on the Date Created button, to sort that column

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.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Menno,
Why dont you start saving your invoices with dates in the file names?
yyyy-mm-dd customer name.xls or so?
Stefan

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.



--
Message posted via http://www.officekb.com

I thought about that. There's other files I do that way. Currently they
all start with the invoice number. I'm going to check in to what everyone
else has suggested here first.
Thanks for the suggestion.

"stefan via OfficeKB.com" wrote in
:


Hi Menno,
Why dont you start saving your invoices with dates in the file names?
yyyy-mm-dd customer name.xls or so?
Stefan

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

"Trevor Shuttleworth" wrote in
:

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.

Nope... it doesn't do that. Actually this is just a slightly modified
copy of the "sample" invoice that came with one of the versions of Excel.
I'm trying to find it now and see if it did it in its original form.

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





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

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