Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2015, 01:03 PM
philippe.delobbe philippe.delobbe is offline Automatically changing Excel source after a folder change Windows 7 64bit Automatically changing Excel source after a folder change Office 2013
Novice
Automatically changing Excel source after a folder change
 
Join Date: Apr 2015
Posts: 2
philippe.delobbe is on a distinguished road
Unhappy Automatically changing Excel source after a folder change

This is my first post in the forums, so if this is not the best place for this question please direct me in the right way.

My situation is this. I have a main word file, 2 Excel sheets, and 2 Visio docs. I have linked 3 tables from Excel sheet A, 1 table from Excel sheet B, and the 2 Visio diagrams into my word file such that they will automatically update in the Word file when they are changed in their main files.



The way they will be used is that they will be copied into different folders and changed uniquely in every folder. I know that I am able to right click on the tables/diagrams and change the source file to the one in the new folder...this is not only time consuming, but my Visio diagrams lose their size formatting every time the source is changed.

My question is: Is there a way, through a Macro or something, to have the links change automatically when they are pasted into the new folder? Or is the only possible way to go through every time and manually change each one's source file?

If I wasn't clear enough, please ask any questions necessary. I appreciate any help I can get.
Reply With Quote
Reply

Tags
excel 2013, linking, word 2013

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2010 changing external link formulas automatically on Webdav mapped drive dirkswart Excel 2 10-07-2013 12:44 PM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 02:01 AM
Automatically changing Excel source after a folder change Automatically Selecting a Data Source Nathan_Newlin Mail Merge 1 12-06-2011 03:42 PM
Automatically changing Excel source after a folder change Old Excel Document folder automatically created in My Documents slickcondo Office 6 07-13-2011 02:31 AM
Automatically changing Excel source after a folder change How do I find the Source folder? PhilAJ Mail Merge 6 04-22-2011 05:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.


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