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

SusieBennett · #8 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!

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