|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I change Excel Chart Object link references from UNC to drive letter?
Hello!
I'm having a problem with Word referring to the UNC (universal naming convention) in the link to a Microsoft Excel Chart Object, and I need to find a way for it to not use the UNC, but rather, the drive letter. Does anyone out there know how to do this? Thanks! Susie |
#2
|
||||
|
||||
If you add the 'Edit Links' icon to Word's QAT, you can use that to change the link path, via its 'change source' button.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Edit Links / Change Source doesn't solve it
Quote:
Thanks for the suggestion. I gave that a try, and saw that I get the same menu as when I right-click the chart and select Edit Links. I typed in the source name the way I wanted it to be (using the drive letter), but then Word changed it right back to the UNC. Maybe someone else has experienced the same thing and found a solution to this? Thanks! Susie Last edited by SusieBennett; 06-11-2014 at 09:50 AM. Reason: To add in quote. |
#4
|
|||
|
|||
Making progress!
I'm cautiously optimistic: After doing more research and playing around, trying fixes to similar issues others have posted on the web, I've been able to make some progress on resolving the problem.
In the Word document, type Alt-F9. Every link or merge field or anything similar that you've included in the document will appear. Go find your chart links, and edit the source there. The change will stick as long as you have it open (including after saving the document), but will revert back upon closing and re-opening. I'm trying different things, like locking the links before closing, telling Word in the Web Options section not to update links upon saving, but nothing I've tried seems to work. I can (and did) create a macro to correct the links, but there's been problems opening the document in one office location if the links were created on the server of the other office location, so I'm worried that the "just press a button to run a macro after you've opened the document" strategy won't work. Any thoughts on getting the change to stick upon closing and re-opening? |
#5
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
Quote:
|
#7
|
||||
|
||||
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#8
|
|||
|
|||
Quote:
I guess I'll have to get started on that macro! |
#9
|
||||
|
||||
Quote:
http://windowssecrets.com/forums/showthread.php/154379-Word-Fields-and-Relative-Paths-to-External-Files
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#10
|
|||
|
|||
Quote:
|
Tags |
drive letter, excel chart object, unc |
Thread Tools | |
Display Modes | |
|
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 |