Aiysha
asked on
change global reference in a workbook.
How can I update references in a workbook when the source workbook has been moved to another location..
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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