Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2014, 03:03 PM
janetb janetb is offline Stop Automatic Date-Update Windows 7 Stop Automatic Date-Update Office 2003
Novice
Stop Automatic Date-Update
 
Join Date: Nov 2010
Posts: 7
janetb is on a distinguished road
Default Stop Automatic Date-Update

I find that sometimes documents I receive (not documents I create!) change the date to the current date every time I open them. These are always from companies, so I assume they have the date field formatted into their letterhead templates to update to the current date. I have a series of letters from a law firm, and they update every time I open or print them, which is very bad, because I need to know when they were written! And when I print them, I want the original date on them!



Is there a way to set my Office programs never to automatically update dates on any docs I open or print? Or never to automatically make any changes to other people's docs?

I find that all posts in forums on this issue tell you how to change this on a particular document you have created/are creating/will create, or for a particular date on a particular document. But I want to know how to keep Word and Excell from changing other peoples' docs when I open or print them. Even if I go back now and select a particular date in a particular doc, I would not know what date to change it back to because I have no idea when it was written--every time I printed it, it changed the date! This has really screwed up my correspondence records..:-(...

Please note that I am using Word 2003 on Windows 7.

Thanks for any suggestions.
Reply With Quote
  #2  
Old 01-23-2014, 04:47 PM
Charles Kenyon Charles Kenyon is offline Stop Automatic Date-Update Windows 7 64bit Stop Automatic Date-Update Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Basic answer: No.

If a date updates, it is because it is a field.
Using Date Fields in Microsoft Word

For your own documents, you may be able to recover the original date by changing it to a CreateDate field (from a Date field). Such fields in any templates you use should be changed to a CreateDate field. Documents created using the template will then have the date the document is created.

For documents you receive from others, you can try it. It may give you the original creation date. I've tried it on documents I've received and the date given predates the Windows creation date shown on my computer.

Problems like this are one of the reasons for saving historical documents as pdf rather than as Word files.
Reply With Quote
  #3  
Old 02-02-2014, 05:02 AM
janetb janetb is offline Stop Automatic Date-Update Windows 7 Stop Automatic Date-Update Office 2003
Novice
Stop Automatic Date-Update
 
Join Date: Nov 2010
Posts: 7
janetb is on a distinguished road
Default Stop Automatic Date-Update

So what do e.g., lawyers do--people who keep all their client files digitally? They can never know what dates other lawyers' letters were written. I'm assuming the law firm I used is not the only one that uses a date field. Should companies who have a date field in their template be doing something to their finished letter to keep the date from changing when the recipient opens it? Seems to me if you are keeping a letter, you are llikely to want to know at some point when it was written....
Reply With Quote
  #4  
Old 02-02-2014, 06:31 AM
Charles Kenyon Charles Kenyon is offline Stop Automatic Date-Update Windows 7 64bit Stop Automatic Date-Update Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I do not - ever - send another lawyer a Word document unless I want him/her to make changes and send it back with the changes - in other words - it is a draft. Likewise with documents sent to clients.

I send pdf. That is the only way I know of to be sure that what the other side sees is what I saw when I sent it. What happens when I send my document to someone else? Will Word mess up my formatting? In addition, Word files can contain metadata, some of which might compromise client confidentiality or negotiation strategy.

When I receive a Word document from another attorney, I save it with a date as part of the name in the client file. I may freeze any dates if I think of it.

Most law firms are well aware of the vagaries of the date field. Many are not aware of metadata or the problems with text reflow.

The simplest way to prevent the problem in your own documents is to use a CREATEDATE field instead of a DATE field in your documents' templates. Using Date Fields in Microsoft Word Another option if not using a template (why aren't you using a template for common documents?) is to simply type the date. Typing the date puts text into the document rather than a field.

Generally when documents are prepared and mailed out physically, they are scanned in my office before they are mailed and the pdf is saved along with the Word version.
Reply With Quote
  #5  
Old 02-02-2014, 07:58 AM
janetb janetb is offline Stop Automatic Date-Update Windows 7 Stop Automatic Date-Update Office 2003
Novice
Stop Automatic Date-Update
 
Join Date: Nov 2010
Posts: 7
janetb is on a distinguished road
Default

Hi Charles,

Like yourself, I would never send out a Word doc.--only pdf. I'm a goldsmith, so all my client correspondence is actually email letters with graphic/image attachments in pdf form. I don't use any Word templates.

I think the legal letter in question for me may have had the constantly-changing date because it was the final copy of a draft going back and forth between us. I believe they send out their letters as hard copy registered mail.

The second time I noticed the problem of a changing date was on an Excel file of tables for my company's discounted UPS rates.
Reply With Quote
  #6  
Old 02-02-2014, 12:25 PM
Charles Kenyon Charles Kenyon is offline Stop Automatic Date-Update Windows 7 64bit Stop Automatic Date-Update Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Don't know much about Excel, sorry.

Again, if you find the DATE field and change it to a CREATEDATE field it will give you something that may be meaningful.
Reply With Quote
  #7  
Old 02-02-2014, 12:39 PM
janetb janetb is offline Stop Automatic Date-Update Windows 7 Stop Automatic Date-Update Office 2003
Novice
Stop Automatic Date-Update
 
Join Date: Nov 2010
Posts: 7
janetb is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
Don't know much about Excel, sorry.

Again, if you find the DATE field and change it to a CREATEDATE field it will give you something that may be meaningful.
Office 2003 does not seem to give a CREATEDATE option--at least not in Word or Excel.... Thus my post....
Reply With Quote
  #8  
Old 02-02-2014, 02:07 PM
Charles Kenyon Charles Kenyon is offline Stop Automatic Date-Update Windows 7 64bit Stop Automatic Date-Update Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Word 97 had and has a CreateDate field. It has been a part of Word for at least that long. Thus my web page which, I believe, was written in 2000.

Using Date Fields in Microsoft Word

It is not an option, it is a field, as is the Date field.
Using Fields in Microsoft Word

If you press Alt+F9 you can search for the document for "date" and likely find the field(s).
Reply With Quote
  #9  
Old 02-02-2014, 02:33 PM
janetb janetb is offline Stop Automatic Date-Update Windows 7 Stop Automatic Date-Update Office 2003
Novice
Stop Automatic Date-Update
 
Join Date: Nov 2010
Posts: 7
janetb is on a distinguished road
Default

What I meant was, CreateDate does not appear in the date's r-click menu in the documents where this was a problem. Please note that most posts on this subject deal with how to set up your own docs, not how to change the automatic date update in your copy of another company's letter which you receive.
Reply With Quote
  #10  
Old 11-09-2016, 06:33 PM
cdscycleandatv cdscycleandatv is offline Stop Automatic Date-Update Windows 8 Stop Automatic Date-Update Office 2010 32bit
Novice
 
Join Date: Nov 2016
Posts: 1
cdscycleandatv is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
I do not - ever - send another lawyer a Word document unless I want him/her to make changes and send it back with the changes - in other words - it is a draft. Likewise with documents sent to clients.

I send pdf. That is the only way I know of to be sure that what the other side sees is what I saw when I sent it. What happens when I send my document to someone else? Will Word mess up my formatting? In addition, Word files can contain metadata, some of which might compromise client confidentiality or negotiation strategy.

When I receive a Word document from another attorney, I save it with a date as part of the name in the client file. I may freeze any dates if I think of it.

Most law firms are well aware of the vagaries of the date field. Many are not aware of metadata or the problems with text reflow.

The simplest way to prevent the problem in your own documents is to use a CREATEDATE field instead of a DATE field in your documents' templates. Using Date Fields in Microsoft Word Another option if not using a template (why aren't you using a template for common documents?) is to simply type the date. Typing the date puts text into the document rather than a field.

Generally when documents are prepared and mailed out physically, they are scanned in my office before they are mailed and the pdf is saved along with the Word version.
I am having a similar problem as janetb, but mine is when I reopen my own documents more so than clients documents. When I receive documents from clients and colleagues I save them with the date I received them as part of the file name. My big problem is that the CREATEDATE is great for documents that only get 1 date in the date field, but I sometimes need to enter multiple dates in 1 date field. Charles you say when the date is entered by typing in the date that it puts text into the document rather than a field. I have been typing the date in, and when I reopen the document all the dates(which are different dates)change to the same date. whether it be the current date or the createdate. I need to be able to stop any and all auto updating. For now I have been using the Crtl- F11 fix but I have to do it on each individual page, and that could be up to 250 pages. I also need to stop the auto updating in my templates, and I have around 300 templates that I use regularly with at least 1 date line per sheet. So Crtl-F11 locks the date field, Ctrl-Shift-F9 converts from a field to text and Ctrl+Shift+F9 unlinks the field. which one should I use, and do I have to do that to each of my templates?
Reply With Quote
  #11  
Old 11-10-2016, 12:05 AM
gmayor's Avatar
gmayor gmayor is offline Stop Automatic Date-Update Windows 10 Stop Automatic Date-Update Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If a simple date is typed as text from the keyboard, it is not going to update any more than if you were to type in this sentence, it would update. If your date is updating, you have inserted a date field. Right click and toggle the field to view the field.

A CREATEDATE field reflects the date the document was created (or saved using SAVEAS). You can insert it as many times as you require in a document and it will always display that date. The problem highlighted with CREATEDATE is that the document is saved using SAVINGAS with a different name. The date you do that then becomes the new CREATEDATE.

You cannot stop a date field from updating. It will update to reflect the system date of the computer when the document is opened and you cannot undo that change. You can change that DATE field to a CREATEDATE field but there is no guarantee that the date thus produced was the intended date.

As long as documents are renamed the CREATEDATE will be an issue. Just make sure that it isn't an issue for others in your documents, by inserting the dates as text and not as fields.

If you are using a template which has lots of Date fields, then unlink them before saving the document for the last time. You can do that with a macro http://www.gmayor.com/installing_macro.htm e.g.

Code:
Option Explicit

Sub UnlinkAllDateFields()
Dim oStory As Range
Dim oFld As Field
    For Each oStory In ActiveDocument.StoryRanges
        For Each oFld In oStory.Fields
            If oFld.Type = wdFieldDate Or oFld.Type = wdFieldDate Then
                oFld.Unlink
            End If
        Next oFld
        If oStory.StoryType <> wdMainTextStory Then
            While Not (oStory.NextStoryRange Is Nothing)
                Set oStory = oStory.NextStoryRange
                For Each oFld In oStory.Fields
                    If oFld.Type = wdFieldDate Or oFld.Type = wdFieldDate Then
                        oFld.Unlink
                    End If
                Next oFld
            Wend
        End If
    Next oStory
    Set oStory = Nothing
lbl_Exit:
    Exit Sub
End Sub
You may also find http://www.gmayor.com/FutureDateAddIn.htm useful?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop Automatic Date-Update TOC update undoes tab stop change to TOC style Dr Wu Word 5 12-10-2013 03:38 PM
Stop Automatic Updating of Links from Excel joatmon Word 4 05-31-2012 10:54 PM
Stop Automatic Date-Update How to stop automatic mail fetching Outlook 2011 for Mac minkowski Outlook 1 04-28-2011 02:28 PM
Linked Image automatic update? uzapuca PowerPoint 0 04-23-2011 02:03 AM
Stop Automatic Date-Update Stop Automatic Slide Transition pgr380 PowerPoint 5 03-25-2011 07:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft