I'm currently facing an issue whereby a raw data worksheet that a lot of other sheets make reference to has become corrupt (formatting on millions of cells and unable to delete the rows / columns without excel showing a message that there are unavailable resources). I'm doing this on a company computer so there is no opportunity for me to download any sort of add-in for to make the adjustments.
Currently, the "Refers To" in the Name Manager is listed as 'Raw Data Balances'. Since I have made a copy of the sheet to try and salvage the data, I would like to change it to 'Raw Data Balances(2)'.
This is the only way I imagine it can be fixed, as deleting the sheet entirely will mess up the formulas everywhere else. If you have any other suggestions please let me know.