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

macropod · #1 06-11-2014, 03:45 PM

Using the Alt-F9 approach is simply a manual method for creating fields - I use it a lot. Of itself, though, that won't prevent Word updating the file path to match your system's UNC names. To do that, you'd have to use a path that points to a physical folder on a physical drive, such as your C drive. I suspect your UNC path points to a virtual drive & folder combination.

SusieBennett · #2 06-11-2014, 04:08 PM

Quote:

Originally Posted by macropod

Using the Alt-F9 approach is simply a manual method for creating fields - I use it a lot. Of itself, though, that won't prevent Word updating the file path to match your system's UNC names. To do that, you'd have to use a path that points to a physical folder on a physical drive, such as your C drive. I suspect your UNC path points to a virtual drive & folder combination.

It is a virtual drive and folder. It's not possible, in this case, to use a physical drive. I'm stuck with the resources I've got. But surely there must be some creative solution to this? Perhaps there's some program floating around out there?

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