Dear Debra

I posted the following messages but no one answered, I thought you might
have the answer. Please help.


1. When deleting calculated fields in my pivot table, Excel crashes.

Plus when deleting a calculated field my pivot table result changed even
when this calculated field is not part of the rest of the calculated fields.
If I set it to zero there is no problem.

Have you had this problem and know why this happening?

2. How can I use macro to create/ammend calculated field using the names and
formula from a table on the spreadsheet?

i.e

A B C
1 Name Formula
2 Cost =Cost A+Cost B New
3 Revenue =Rev A+Rev B Existing



Where the calculated field Cost is calculated field to be created and
Revenue is an existing one requiring to be Modify