What happened when you built the smaller workbook and ran the test?

nc wrote:

Thanks Dave for your reply.

I tried help|detect and repair. But it did not solve the problem.

This is the repair log,

Repairs were made to PivotTable report 'PivotTable9' on '[TAS summary
2005-06 II.xls]FAH'.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.
Global PivotTable report information was repaired due to integrity problems.

My main concern, there is no reason for the result of the pivottable
changing when I delete a calculated field that is not being used anywhere in
the pivottable or part of another calculated field. I can confirm the fact
because I have tool|find to search the list of calculated fileds.

"Dave Peterson" wrote:

I'm not Debra, but if excel were crashing when I was doing something that seems
normal, I'd suspect a couple of things.

#1. A corrupted workbook. I'd try building a smaller version of the same
workbook (just enough data to test) and see what happens. If it worked in that
test workbook, I'd rebuild the real version.

#2. A corrupted installation of excel. Maybe help|detect and repair or
reinstalling excel would help.

In fact, I think I'd do some more detective work. Maybe test the workbook on a
different pc to see what happens. Maybe it'll help isolate the error.



nc wrote:

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

--

Dave Peterson


--

Dave Peterson