Solved Changing worksheet name in formulas

November 9, 2011 at 10:08:00
Specs: Windows XP
If I rename a worksheet, will the new name automatically be updated in formulas and/or pivot tables that reference that worksheet?

If not, is there a quick way to find all the formulas and/or pivot tables in the workbook that reference that worksheet so that I can change all of the affected references?



See More: Changing worksheet name in formulas

Report •


#1
November 9, 2011 at 10:53:39
✔ Best Answer
It depends.

If you are renaming sheets within the same workbook as the references, all references should be updated automatically - assuming you have not used any INDIRECT references to those sheets.

If you are renaming sheets in a different workbook than the references and both workbook are open at the time, all references should be updated automatically - assuming you have not used any INDIRECT references to those sheets.

If you are renaming sheets in a different workbook than the references and the workbook with the references is closed, odds are that the references will be lost.

Please note that all of those statements are based on some limited testing and some longer term experience. They are worth every penny you paid for them, so I would be very cautious and make sure I had backup copies of everything before I started renaming sheets and saving files.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
November 9, 2011 at 11:00:15
Thanks!

Yes, everything is within the same workbook!

You are correct. It worked perfectly!


Report •
Related Solutions


Ask Question