Hi!

I'm considering a document project where I have templates linked to cells in a different sheet to update text boxes and charts.
However, I found that Excel resets the formatting of text boxes to the default format when I need to change the text box's formula.
Is there a way that I can somehow stop Excel from doing that?

Thanks in advance for any advice.