| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas Aren't Automatically Updating When Cells Change | Excel Discussion (Misc queries) | |||
| Formulas updating | Excel Worksheet Functions | |||
| updating formulas | Excel Discussion (Misc queries) | |||
| Formulas not recalculating when values change on another sheet | Excel Worksheet Functions | |||
| Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
Threaded Mode
