Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-08-2015, 05:36 AM
barneyrubble1965 barneyrubble1965 is offline Linking Date in one Doc to another Doc Windows 7 64bit Linking Date in one Doc to another Doc Office 2010 64bit
Novice
Linking Date in one Doc to another Doc
 
Join Date: May 2015
Posts: 6
barneyrubble1965 is on a distinguished road
Default Linking Date in one Doc to another Doc


I want to create a table in word and one of the columns will be called 'review date'. The dates in this column will be the dates that have been added as text in another document at the end. e.g One document will have a box titled 'Next review date'. a date will then be typed into this box for instance '07/05/16' I would then like the other word document to pick up this date automatically on opening and be able to update itself as and when the 'next review date is changed. I hope that is clear and any help anybody can give me in achieving this would be most appreciated.
Reply With Quote
  #2  
Old 05-08-2015, 07:09 AM
Charles Kenyon Charles Kenyon is offline Linking Date in one Doc to another Doc Windows 8 Linking Date in one Doc to another Doc Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
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

So we are clear.
Doc1 = letter about somthing that includes Review Date
Doc2 = table that includes review dates

How does Doc2 know to look in Doc1? How does Doc2 know about Doc1?
Reply With Quote
  #3  
Old 05-08-2015, 12:15 PM
barneyrubble1965 barneyrubble1965 is offline Linking Date in one Doc to another Doc Windows 7 64bit Linking Date in one Doc to another Doc Office 2010 64bit
Novice
Linking Date in one Doc to another Doc
 
Join Date: May 2015
Posts: 6
barneyrubble1965 is on a distinguished road
Default

Other columns in Doc 2 have hyperlinks to other documents on our server. I was hoping that it was possible for one column to look at review dates (which could be a hyperlinked text) within other documents and inform the person opening Doc 2 whether the document was still valid, in other words that it hadn't exceeded the review date. I used to be able to do a similar thing when linking an excel spreadsheet to a word document.
Reply With Quote
  #4  
Old 06-04-2015, 01:07 AM
barneyrubble1965 barneyrubble1965 is offline Linking Date in one Doc to another Doc Windows 7 64bit Linking Date in one Doc to another Doc Office 2010 64bit
Novice
Linking Date in one Doc to another Doc
 
Join Date: May 2015
Posts: 6
barneyrubble1965 is on a distinguished road
Default

Still trying to work this out. I used to be able to do something similar when linking an excel file to word by using something called 'OLE'. I want to link two word documents now but one of them (DOC1) will show the review date that is typed into DOC2. Is this possible ??
Reply With Quote
  #5  
Old 06-04-2015, 05:40 AM
Charles Kenyon Charles Kenyon is offline Linking Date in one Doc to another Doc Windows 8 Linking Date in one Doc to another Doc Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
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

Yes, in several ways.
The date in DOC2 must be marked with a bookmark.
You can use an INCLUDETEXT or a LINK field to refer to it.
Note that these links tend to break if you move the documents around.

See https://support.microsoft.com/en-us/...?wa=wsignin1.0.
Reply With Quote
  #6  
Old 06-08-2015, 06:41 AM
barneyrubble1965 barneyrubble1965 is offline Linking Date in one Doc to another Doc Windows 7 64bit Linking Date in one Doc to another Doc Office 2010 64bit
Novice
Linking Date in one Doc to another Doc
 
Join Date: May 2015
Posts: 6
barneyrubble1965 is on a distinguished road
Default

I've tried several times now but always get the message - Error! Not a valid link.
Reply With Quote
  #7  
Old 06-08-2015, 11:30 AM
Charles Kenyon Charles Kenyon is offline Linking Date in one Doc to another Doc Windows 8 Linking Date in one Doc to another Doc Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
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

What steps are you taking to create or generate the link?
Reply With Quote
  #8  
Old 06-08-2015, 11:16 PM
barneyrubble1965 barneyrubble1965 is offline Linking Date in one Doc to another Doc Windows 7 64bit Linking Date in one Doc to another Doc Office 2010 64bit
Novice
Linking Date in one Doc to another Doc
 
Join Date: May 2015
Posts: 6
barneyrubble1965 is on a distinguished road
Default

I set up a table in document 1 with one of the columns referring to a review date. In row 1 fir instance the review date was "Jan 2016". I then inserted a bookmark around this date (called ReviewDate). In document 2, I tried to use the link field command listed "Insert, Quick part, Field" and tried to follow the procedure for linking file, bookmark and auto update to give the date Jan 2016 in a cell within a table but kept getting the message "Error! not a valid link"
Reply With Quote
  #9  
Old 06-09-2015, 06:55 AM
Charles Kenyon Charles Kenyon is offline Linking Date in one Doc to another Doc Windows 8 Linking Date in one Doc to another Doc Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
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 know it is tedious, but
Quote:
I tried to use the link field command listed "Insert, Quick part, Field" and tried to follow the procedure for linking file, bookmark and auto update to give the date Jan 2016 in a cell within a table but kept getting the message "Error! not a valid link"
does not tell me exactly what steps you are taking, just that you are trying.
Reply With Quote
  #10  
Old 06-10-2015, 06:07 AM
barneyrubble1965 barneyrubble1965 is offline Linking Date in one Doc to another Doc Windows 7 64bit Linking Date in one Doc to another Doc Office 2010 64bit
Novice
Linking Date in one Doc to another Doc
 
Join Date: May 2015
Posts: 6
barneyrubble1965 is on a distinguished road
Default

Not really sure what you are asking, but I'll attempt to lay it out my procedures. (incidentally, I took my query up to IT services on the university campus, they are running Word2013 as opposed to Word 2010 and the link I had created worked straight away without any additional input from them so I'm beginning to think it is a Word 2010 problem !!
On opening Quick parts, I choose <Field> and then <Link> for class name I choose <word.document.8> I think the problem stems from here, under filename or url I type E:\document1.docx ReviewDate (with or without [] - makes no difference) and then tick update fields automatically. I either get the message "Error! not a valid link" or "Word is unable to create a link to the object you specified. Please insert the object directly into your file without creating a link"
Reply With Quote
  #11  
Old 06-10-2015, 02:04 PM
Charles Kenyon Charles Kenyon is offline Linking Date in one Doc to another Doc Windows 8 Linking Date in one Doc to another Doc Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
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

OK. I am able to replicate the error message (in both Word 2010 and 2013). I don't use LINK fields, myself, so am unable to provide more insight.

Note that I do not get the error message when I link to the file without using a bookmark.

This is the MS reference page on the field but it didn't help me.
https://support.office.com/en-us/art...rs=en-US&ad=US
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Date in one Doc to another Doc How can a document have the same date modified/create date, yes have have actual file content? legaleagle Word 15 01-07-2015 06:58 PM
Excel pivot table with a DATE value field for some reason stops at a certain date angie450 Excel Programming 2 08-19-2014 08:50 AM
Letter date changes when merging with Excel - not the format, the actual date! Smallweed Mail Merge 1 02-07-2014 06:00 PM
Linking Date Picker to a Calendar Table Vamosj Word 13 11-26-2013 12:11 PM
Make table cell active add date count date MelHerndon Word VBA 3 01-21-2013 04:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:45 AM.


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