Forum Discussion
Updating Sheet Name References after Changing Sheet Name
I do understand that when using sheet name references under normal circumstances, the formula does re-write itself if you change the sheet names. But you can see here that after I change the names to Feb, if I use the INDIRECT function to call the sheet references, the formula doesn't automatically change.
I've found a work around using find and replace, it should be all good now. Though if you have a simple solution that doesn't need find and replace, I'd be open to hearing it.
HelloTony_Nguyen, I guess this has to do with LINKS.
When you have a formula that refers to cells, and then you copy that worksheet to another place, renaming also does the same you will produce links. these links look at the original formula and the cells it point to. If you would go to the Data tab, and you will see the button activated you have links. No links are in my workbook
And now you see the button is active
Using this Edit Links button will allow you to redirect the link to where it should be. if you have many you many want to write some VBA code.