I'm trying to remember if there is a way to prevent a shape from auto-reformatting when I update the cell reference it is linked to.
For example, I have a text box that contains the reference ='[Driver1]YoY Delta'!$C$1. I have been copying tabs from one workbook to another, so when it comes...