Share via

How do I prevent a field from updating when I open the document

Anonymous
2012-03-06T13:21:36+00:00

I recently found out I could use Shilft-Alt-D and Shift-Alt-T to insert the current date and time in my document.  Felt this would be great to keep track of the time I worked on customer requests, so would do a timestamp when I started, and timestamp when I finished, thinking I could later open the document and do my hours calculation.

Unfortunately, when I opened the document later, it put the current date and time in all the existing fields! 

Is there a way to open that document so the original dates and times dont get updated automatically?  I'd like to recover the original values so I can bill!

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Suzanne S Barnhill 277.1K Reputation points MVP Volunteer Moderator
    2012-03-06T13:38:09+00:00

    If you want to use the keyboard shortcuts to insert the date and time, you can continue to do so; just add another step: immediately after inserting the field, click in it and press Ctrl+Shift+F9 to unlink it. This will convert it to plain text, and it won't update.

    If, on the other hand, you're creating a new document for each customer request, then it would be more efficient to create a template that includes the CreateDate field. This will update once, when you create a new document based on the template, and then remain constant. That will give you the starting time; you'd still need to insert (and unlink) your time field when you close the document (OTOH, if you just need the elapsed time, you can look at the Total Editing Time in the document Properties).

    10+ people found this answer helpful.
    0 comments No comments

Answer accepted by question author

  1. Anonymous
    2012-03-06T21:34:53+00:00

    I thought the following would help, but no.  Do you think if I tried ti import my unopened document into another program would forgo the field updates for this one time?

    http://support.microsoft.com/kb/918793

    Disable the "Update automatic links on Open" option

    When you disable the Update automatic links on Open option, documents may open faster. You can manually update links later.

    To disable the Update automatic links on Open option, follow these steps: 1.Start Word.

    2.In Word 2007, click the Microsoft Office Button (In Word 2010, click File), and then click Word Options.

     3.In the Word Options dialog box, click Advanced, and then scroll down to the General section.

    1. Click to clear the Update automatic links on Open check box, and then click OK.

    To manually update links, follow these steps: 1.Start Word.

    2.In Word 2007, click the Microsoft Office Button (In Word 2010, click File), point to Finish, and then click Edit Links to Files.

     3. Click the link that you want to update, and then click Update Now.

    8 people found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Suzanne S Barnhill 277.1K Reputation points MVP Volunteer Moderator
    2012-03-07T00:30:47+00:00

    Unfortunately "links" are not the same thing as "fields." I can't speak to what might happen if you open the file in another application (if that's even possible).

    0 comments No comments
  2. Suzanne S Barnhill 277.1K Reputation points MVP Volunteer Moderator
    2012-03-06T18:48:04+00:00

    I don't know of any way to do that. You could substitute the CreateDate field for the Date field, but a CreateDate field, IIRC, can be only the date, not the time, so that probably wouldn't be helpful for a starting point, timewise (though it would provide the date). But the Total Editing Time should be helpful, and the document Properties will also give you the date and time when the document was created and the date and time when it was last saved.

    The document Properties are shown on the Info tab of the File tab in Word 2010, which is the tab displayed by default when you select the File tab in an open document.

    Oops, sorry, just noticed you're using Word 2007, which makes it much more of a pain to get to the document Properties: Office Button | Prepare | Properties, then click Document Properties and then Advanced Properties. The statistics you need are on the Statistics tab. You may find it helpful to add the Advanced Document Properties command to the QAT.

    0 comments No comments
  3. Anonymous
    2012-03-06T15:28:21+00:00

    Thanks for that, Suzanne.  I will use that unlink function from now on. 

    Now, is there a way you think to open my old document without the fields updating?  Maybe importing it into something else?  Some king of debug Open mode that says open but don't update the linked fields so I can get the original data in my existing old document?

    0 comments No comments