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