At this rate , we will never get anywhere.
Can you mention just one worksheet cell and the worksheet tab where you have a formula which needs to be corrected ?
Just one worksheet cell.
Just one worksheet tab.
Unless this is given , please do not bother to reply with anything else.
Doing this without VBA is risky because it is entirely dependent on the recalculation method being manual.
Excel has no foolproof formulaic method for detecting transitions , which is what you want here.
VBA has the Worksheet_Change event which recognizes when a worksheet cell has been...
I have opened your workbook in Excel 2010 , and the same behaviour is present.
What ever be the font of those cells which contain the formulas , what ever be the font size , the moment a new row is added to the table , the font of those cells changes to Calibri , font size 11...