How do I change the Sheet name without updating formulas?
On Aug 14, 3:11*pm, Duke Carey
wrote:
One way - use the Indirect() function to reference your vlookup() table
range. Indirect converts a text string that looks like a range address to an
actual range address.
So, with a range named Table on the Formulas sheet and a range named Table
on the Formulas_Old sheet, this formula will sum the Table range on whichever
sheet is referenced in cell E3
=SUM(INDIRECT(E3&"!table"))
" wrote:
On Aug 14, 2:36 pm, MyVeryOwnSelf wrote:
As the subject says: All I want to do is change the sheet name from
"Formulas" to "Formulas_Old" without all of my formulas updating to
the new sheetname.
One way with Excel 2003 is to make a copy of the sheet, rename it as
desired, *and then delete the original one. Naturally links to the sheet
from others will be broken because they refer to the now-deleted sheet.
|