I have a workbook that I copied and I need to change the tab name.

D

Dawnel

I have a workbook that I copied and I need to change the tab names
without screwing up the formulas and links, but updating with the new tab
names.

How can I do this?
 
M

Myrna Larson

Formulas that include sheet names will be fixed automatically by Excel when
you rename a sheet. The same is not true of any VBA code. That will have to be
modified manually.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Consolidation Table from Different Excel Tabs with Different Format 1
Use a master workbook to carry over changes to multiple workbooks 1
Word 2016 - Difficulties Learning Style Creation/Application 0
renaming tabs to fit formulas 0
Link To File That No Longer Exists 1
Cells not updated automatically 3
Sumif apllying to all sheets in workbook 2

Top