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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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