• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

change global reference in a workbook.

How can I update references in a workbook when the source workbook has been moved to another location..
0
Aiysha
Asked:
Aiysha
1 Solution
 
Shanan212Commented:
Find & Replace is one option.

When you are doing this, you must set 'Look In' option to 'Formulas' under the Options on the 'Find & Replace' window

Find the previous name and replace it with new source directory and name
0
 
AiyshaAuthor Commented:
The problem is I have charts that are referencing/retreiving data from the master spreadsheet..so how do I update the reference to master spreadsheet for the charts?
0
 
dlmilleCommented:
Use your link manager to update links.  Hit Alt+E+K then click on the workbook needing a change in location.  Change the source location following the wizard and you should be in good shape.  All formulas that reference that original workbook location will then reference it in the new location - even chart formulas.  You can even specify a different workbook name as your new source, independent of location.

Here's a link to a quick tip with the steps:
http://www.exceltip.com/st/Changing_the_Source_Link_in_Excel_2007/1370.html

PS - if you have split out a workbook into multiple workbooks and are having link problems, please read this related article (a YES vote would  be appreciated!):
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_9730-Workbook-link-problems-after-copying-tabs-to-a-new-workbook.html

Dave
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now