I have an Excel sheet with diagrams containing text boxes (see below) with each text box linked to a cell on another sheet.
I want to copy this sheet, then bulk search and replace the sheet name in the linked formulas to point to a different location.
Is it possible to search and replace within formulas that are linked to text boxes?