"locking" a document after saving it

I use Word and Excel to create my invoices. What I need to do is, once the
document is saved, to NOT have it updated when ever I update excel and then
open the document again. I need to show the info as it was at the time
service was performed. How can I prevent the feilds from being refreshed?

Thanks
Bruce

Best thing to do is to convert the document to a .pdf file. Check out
PrimoPDF for a free converter.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Bruce" oleexpres.at.johnsonclan.net wrote in message
...
I use Word and Excel to create my invoices. What I need to do is, once the
document is saved, to NOT have it updated when ever I update excel and then
open the document again. I need to show the info as it was at the time
service was performed. How can I prevent the feilds from being refreshed?

Thanks
Bruce

Break the link with Excel - CTRL+A then CTRL+SHIFT+F9
or by macro

Sub BreakLink()
Selection.WholeStory
Selection.Fields.Unlink
End Sub

You could incorporate this in the file save routine in your invoice template

Sub FileSave()
Selection.WholeStory
Selection.Fields.Unlink
ActiveDocument.Save
End Sub

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Bruce wrote:
I use Word and Excel to create my invoices. What I need to do is,
once the document is saved, to NOT have it updated when ever I update
excel and then open the document again. I need to show the info as it
was at the time service was performed. How can I prevent the feilds
from being refreshed?
Thanks
Bruce