LIMITED COLUMNS IN EXCEL BOM

I am having trouble adding more columns in an excel BOM. Ihavedouble-clicked to edit and added my necessary columns, but wheniclick away, it regenerates back to only 8 columns totalincludingtheir pre-defined columns. The same seems to happen when Iadd arow without a item number (as in totaling costs and othercolumns).Has anyone found a way to get around this problem?SolidworksBill Of Materials