<div>
Find &amp;&nbsp;Replace is one option.<br />
<br />
When you are doing this, you must set 'Look In' option to 'Formulas' under the Options on the 'Find &amp;&nbsp;Replace' window<br />
<br />
Find the previous name and replace it with new source directory and name
</div>


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

<div>
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?
</div>


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?

<div>
<div class="content wysiwyg-content">
How can I update references in a workbook when the source workbook has been moved to another location..
</div>
</div>


How can I update references in a workbook when the source workbook has been moved to another location..

change global reference in a workbook.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.