Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

change global reference in a workbook.

Posted on 2012-04-10
3
Medium Priority
?
226 Views
Last Modified: 2012-04-12
How can I update references in a workbook when the source workbook has been moved to another location..
0
Comment
Question by:Aiysha
3 Comments
 
LVL 13

Expert Comment

by:Shanan212
ID: 37829926
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
 

Author Comment

by:Aiysha
ID: 37829933
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
 
LVL 42

Accepted Solution

by:
dlmille earned 2000 total points
ID: 37830043
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question