Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-11-2014, 11:21 AM
SusieBennett SusieBennett is offline How do I change Excel Chart Object link references from UNC to drive letter? Windows 7 64bit How do I change Excel Chart Object link references from UNC to drive letter? Office 2010 64bit
Novice
How do I change Excel Chart Object link references from UNC to drive letter?
 
Join Date: Jun 2014
Posts: 6
SusieBennett is on a distinguished road
Lightbulb 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?
Reply With Quote
 

Tags
drive letter, excel chart object, unc



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 do I change Excel Chart Object link references from UNC to drive letter? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft