I'm using Excel 2002. I have a very simple pivot table with 'Product' in the
row and 'Cost' in the data.

The problem is, I was playing around trying to learn calculated items and
created a calculated item that I don't need -- but is now causing me problems.

Since I've created the calculated item, I can no longer have a data field in
two locations (e.g., having 'Product' not only in the row but also in the
data area).

I've tried to delete the calculated field but it just gives me an error that
says 'Pivot Table field name is not valid . . . '

If I copy the source data into a completely new spreadsheet and re-create
the pivot table it works fine so I know the calculated field is causing the
problem. Can someone tell me how to get rid of it?

(Even though the example I used above is a simple pivot table, I actually
have about 15 complicated pivot tables in this spreadsheet so re-creating
them all would be a big pain.)

Thanks for your help!