Forum Discussion
How to remove Legacy Formula in Excel Table that are pasted automatically?
Hi all, I am trying to get rid of some legacy formulas in one of my Excel table. When trying to remove the content in the table or pasting everything as values, I can still find the XML tag <calc...
Hi Edouard,
Interesting question. IMHO, as soon as calculatedColumnFormula tag appeared in Table.xml you can't remove it within UI.
Tag appears if you enter the formula into the any cell of empty column or if you copy the formula into all cells.
The solution could be if you create new column (doesn't matter what will be AutoCorrect option "Fill formulas..."), move your data here from "old" column (e.g. as copy/paste values) and remove it after that. After that you may add formulas to cells, but don't expand them on entire column.
After that adding new rows to the table shall not add formula in that column.