Thread: Excel 2007 Table adding unwanted formulas to new rows

I have an Excel 2007 Table that I created that originally had several formulas in various columns. When I add a new row it copies those formulas and puts then in the corresponding cells in the new row.

Now I have changed the table and I no longer need the formulas in these columns. I have deleted all the formulas in the columns. Excel still creates formulas in the corresponding cells when I add a new row even though i have deleted all the formulas in the rows of the table.

How do I get Excel to stop automatically creating formulas in new rows of a table?

This is still driving me crazy? Anyone else had this problem?

I have done as you suggested and converted the table to a range and then converted it back to a table again. This works but is a total PITA because I have to redo all the references that referenced the table name. You would think there would be a way to suppress the automatic creation of formulas without having to remove all the table properties.