Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-09-2020, 03:59 PM
SamVDS SamVDS is offline Word relative link to excel - How can you explain this ? Windows 10 Word relative link to excel - How can you explain this ? Office 2019
Novice
Word relative link to excel - How can you explain this ?
 
Join Date: Apr 2020
Posts: 4
SamVDS is on a distinguished road
Default Word relative link to excel - How can you explain this ?

Ok guys,




So I did alot of research on how to 'relative link' an excel file to a word doc. The thing is, I had been doing this for years. I had a excelfile and a worddoc who always kept being synced, no matter where I moved them to or whatever I renamed the path to. Today I tried making a new exceldoc that kept in sync with the word doc, but I cannot seem to make it work. The word doc keeps linking with the original pathway when I try moving or renaming the original structure.


I have read alot about this and everyone keeps stating that it is not possible to keep them linked. Well, I can tell you 100% sure that it IS pssoble. As a way of proving this, I have screen recorded a test with my previous well-linked files. A little extra info :

1) I change a value in my original excel doc and you see it synced with the word doc
2) I copy/paste the folder to another drive and rename it
3) You see me changing a value in the new excel doc and then open up the word doc, which is updating to the correct values.
4) to prove even further I press ALT+F9 to show you that the linked information has in fact changed to the new folder structure.


Can someone PLEASE tell me why this is no longer working when trying to replicate this linking in a new word and excel-doc ???


Link to the screen recording :
Relative link ??? - YouTube
Reply With Quote
  #2  
Old 04-09-2020, 06:59 PM
macropod's Avatar
macropod macropod is offline Word relative link to excel - How can you explain this ? Windows 7 64bit Word relative link to excel - How can you explain this ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Links from Word to Excel use LINK fields, as your video demonstrates. As clearly stated in the Word Fields and Relative Paths to External Files 'Sticky' thread at the top of this forum (https://www.msofficeforums.com/word/...nal-files.html), however, all Word field paths are absolute; they have never been relative. As also explained in that thread, whilst field coding can be used to make other kinds of field employ relative paths, it is not possible to make LINK fields behave as if they had relative paths.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-10-2020, 01:03 AM
SamVDS SamVDS is offline Word relative link to excel - How can you explain this ? Windows 10 Word relative link to excel - How can you explain this ? Office 2019
Novice
Word relative link to excel - How can you explain this ?
 
Join Date: Apr 2020
Posts: 4
SamVDS is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Links from Word to Excel use LINK fields, as your video demonstrates. As clearly stated in the Word Fields and Relative Paths to External Files 'Sticky' thread at the top of this forum (https://www.msofficeforums.com/word/...nal-files.html), however, all Word field paths are absolute; they have never been relative. As also explained in that thread, whilst field coding can be used to make other kinds of field employ relative paths, it is not possible to make LINK fields behave as if they had relative paths.
Thanks for your reply.
Have you taken a look at the video I posted ? You can clearly see that the path is dynamic, as it changes automatically when i move the folder around or rename it. How can this be explained then? I read the sticky btw but I still believe that the files I have behave in a way that cannot ben explained by this thread...
Reply With Quote
  #4  
Old 04-10-2020, 01:24 AM
macropod's Avatar
macropod macropod is offline Word relative link to excel - How can you explain this ? Windows 7 64bit Word relative link to excel - How can you explain this ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What your document demonstrates is the use of the Hyperlink Base. See: How to create absolute hyperlinks and relative hyperlinks in Word documents - Microsoft Support . Although MS refers to these as relative links, they aren't relative in the true sense. Moreover, using the Hyperlink Base messes around with internal document links also.

PS: As there's no audio in the video - which is low resolution - and nothing in your original post described what you were doing, few would likely pick what was going on.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 04-10-2020, 01:31 AM
SamVDS SamVDS is offline Word relative link to excel - How can you explain this ? Windows 10 Word relative link to excel - How can you explain this ? Office 2019
Novice
Word relative link to excel - How can you explain this ?
 
Join Date: Apr 2020
Posts: 4
SamVDS is on a distinguished road
Default

So, I have read the sticky again, and I can still conclude that the fact that I can move around and rename the path where the files are stored in, does not change anything, it behaves as if they are relative and the path always updates. In the video you see me doing this and the 'absolute' paths immediately update when opening the linked word doc, as i demonstrate in my vid. It is clear that I have created something godly, as noone (not even me) can ever recreate this behaviour!

PS : Sorry didnt read your reply yet
Reply With Quote
  #6  
Old 04-10-2020, 01:35 AM
SamVDS SamVDS is offline Word relative link to excel - How can you explain this ? Windows 10 Word relative link to excel - How can you explain this ? Office 2019
Novice
Word relative link to excel - How can you explain this ?
 
Join Date: Apr 2020
Posts: 4
SamVDS is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
What your document demonstrates is the use of the Hyperlink Base. See: How to create absolute hyperlinks and relative hyperlinks in Word documents - Microsoft Support . Although MS refers to these as relative links, they aren't relative in the true sense. Moreover, using the Hyperlink Base messes around with internal document links also.

PS: As there's no audio in the video - which is low resolution - and nothing in your original post described what you were doing, few would likely pick what was going on.
I will read into this.
Too bad the video isn't working. It indeed had no audio but the resolution should be top notch. Probably a YouTube setting somewhere ?
Reply With Quote
  #7  
Old 04-10-2020, 01:41 AM
macropod's Avatar
macropod macropod is offline Word relative link to excel - How can you explain this ? Windows 7 64bit Word relative link to excel - How can you explain this ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by SamVDS View Post
Too bad the video isn't working. It indeed had no audio but the resolution should be top notch. Probably a YouTube setting somewhere ?
The YouTube setting was auto - which is what most people would use. In any event, the max resolution supported by your video is only 720p.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word relative link to excel - How can you explain this ? Can anyone explain how Office 365 works? Moondoggy Office 2 01-25-2019 06:23 PM
Word relative link to excel - How can you explain this ? Relative link (same folder) from Excel cell into Word file SparFuX Word 1 12-18-2018 03:22 PM
Word relative link to excel - How can you explain this ? Excel Link in word chandan56 Office 3 07-02-2015 07:07 PM
link excel to word ganeshm Office 1 03-27-2013 01:29 AM
Word relative link to excel - How can you explain this ? Relative path for video link? Is it possible? Baudisson PowerPoint 1 01-10-2012 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:01 PM.


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