How do I change Excel Chart Object link references from UNC to drive letter?

SusieBennett · #1 06-16-2014, 10:30 AM

Quote:

Originally Posted by macropod

Sure, you could use a macro to change it back to a conventional path every time the document is opened, but Word will still only save the UNC path when you close the document. You can't prevent that. Besides which, I don't see that doing so achieves anything.

It achieves something when the alternative is to have the document "blow up" on you when you try opening it in a different office location (on a different server) from the one you last saved it!

I guess I'll have to get started on that macro!

macropod · #2 06-16-2014, 03:53 PM

Quote:

Originally Posted by SusieBennett

It achieves something when the alternative is to have the document "blow up" on you when you try opening it in a different office location (on a different server) from the one you last saved it!

Changing it to a physical path won't fix that, either. For that, you need to use a relative path, which LINK fields don't support. To see how to implement relative paths in Word, check out the macro solution I've posted at:
http://windowssecrets.com/forums/showthread.php/154379-Word-Fields-and-Relative-Paths-to-External-Files

SusieBennett · #3 06-16-2014, 05:58 PM

Quote:

Originally Posted by macropod

Changing it to a physical path won't fix that, either. For that, you need to use a relative path, which LINK fields don't support. To see how to implement relative paths in Word, check out the macro solution I've posted at:
http://windowssecrets.com/forums/showthread.php/154379-Word-Fields-and-Relative-Paths-to-External-Files

Oooh! That looks like an even better fix!! I just have to put the files into the same folder so it will work (and update all the various links and macros accordingly), then I'm going to give it a try!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update Link very slow -PowerPoint Charts & object, cells etc Linked to Excel	johnseito	PowerPoint	0	01-28-2014 06:24 PM
Excel 2010 changing external link formulas automatically on Webdav mapped drive	dirkswart	Excel	2	10-07-2013 12:44 PM
How to dynamically link imbedded Excel chart with source data from Word	TBoz	Excel	1	07-06-2012 05:53 PM
option Paste special...as 'Microsoft Excel Chart Object' NOT available	Intruder	PowerPoint	0	12-24-2010 06:28 AM
Problem: object library invalid or contains references to object definitions	aligahk06	Office	0	08-19-2010 12:29 PM