<div>
One way is to <br />
<br />
copy the tab to the workbook first <br />
then perform a search/replace for the tab names from the old one to the new one<br />
and then delete the old tab.<br />
<br />
This may cause a problem if your formula contains the old tab name as text string etc which will also get changed.
</div>


One way is to

copy the tab to the workbook first
then perform a search/replace for the tab names from the old one to the new one
and then delete the old tab.

This may cause a problem if your formula contains the old tab name as text string etc which will also get changed.

<div>
I did this a little differently. &nbsp;But, it got the job done.<br />
<br />
Thanks
</div>


I did this a little differently.  But, it got the job done.

Thanks

<div>
<div class="content wysiwyg-content">
I have a tab in my excel workbook that other tabs reference. &nbsp;I have to replace this tab each week with the current version. &nbsp;i can either copy/paste the data from the new tab into the existing one. &nbsp;Or I can copy the entire tab from the new spreadsheet into the workbook and ensure the tab names are correct. &nbsp;I can do either.<br />
<br />
Here's my problem. &nbsp;As soon as I delete the tab/data that the formulas were using, the entire spreadsheet that referenced any of those cells return &quot;REF!&quot; in the formulas. &nbsp;<br />
<br />
Can I turn off automatic calculate or something like that to prevent this from happening each week?
</div>
</div>


I have a tab in my excel workbook that other tabs reference.  I have to replace this tab each week with the current version.  i can either copy/paste the data from the new tab into the existing one.  Or I can copy the entire tab from the new spreadsheet into the workbook and ensure the tab names are correct.  I can do either.

Here's my problem.  As soon as I delete the tab/data that the formulas were using, the entire spreadsheet that referenced any of those cells return "REF!" in the formulas.  

Can I turn off automatic calculate or something like that to prevent this from happening each week?

Replacing tabs in excel when those tabs are referenced in formulas

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