Retain text formatting after changing formula references inside shapes/textboxes
This has been a bug (in my mind) forever. For some reason, if you have an Excel shape nicely formatted and you go to link it to a cell to make the text dynamic, all the text formatting gets reset. This is really extremely annoying if you are creating a visually stimulating dashboard and want to duplicate a bunch of perfectly formatted shapes. Proceeding to link the shapes to various cells so that they display your data completely resets the formatting.
I created a VBA workaround to make it seem like the text format is retained, but this functionality should really be integrated into Excel itself.
All of the Excel auto-format functionality is bad, and there's no way to switch it off. One little option to disable auto-formatting and all my Excel problems would be fixed!
It's a broader problem in Excel.
Another example is, for Excel 2013, if I set an indent for a column (horizontal positioning), then later changed the vertical positioning, the indent disappeared, just gone. I was force-upgraded by the boss so now I have 365 and it does not happen there.
So these things exist across the product but it seems they CAN be fixed. With any luck, they'll do this one soon.
Sergei Baklan commented
Yes, that's quite annoying
Wyn Hopkins commented
Totally agree, these things may seem minor but when you use them a lot it really detracts from the efficiency of development
Not only does it do that when you use text formulas, but if you cut or copy text from one part of the shape and move it to another location in the same shape, it will also remove the formatting.