Excel 2007 : Excel 2007 Table adding unwanted formulas to new rows

[BFid]

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?

[BFid]

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

[alansidman]

In Excel 2007. Highlight your table. Click on the design tab on the ribbon. Then select Convert to Range in the tools section of the ribbon. This will remove the table properties from your table.

Alan

[BFid]

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.