I need a solution
change global reference in a workbook.
How can I update references in a workbook when the source workbook has been moved to another location..
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
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?
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:
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!):
Solve your biggest tech problems alongside global tech experts with 1:1 help.
Tackle projects and never again get stuck behind a technical roadblock.
How it Works
Plans and Pricing
Become an Expert
Who We Are
Join Our Team
Hall of Fame
Experts Exchange, LLC.
All rights reserved. Covered by US Patent.