#DIV/0 Pivot Table Problem on Calculated Field

[Frank & Pam Hayes]

Hi,

I have a very large Excel workbook, approximately 95 Megs, 37,000 rows and
50 columns. It has a pivot table with a number of calculated fields, all of
which appear to be working fine except one. This field works up to about
10,000 records, but if I increase the number of records much beyond that it
will return #DIV/0. The calculation DOES NOT have a divisor in it. It is
straight subtraction.

I think it is just a memory error due to the size of the workbook. Any
other thoughts or work arounds?

Thanks,

Frank Hayes

 

[Charles Williams]

Anything is possible but it is very unlikely that memory problems cause a
#div/0.
10000 records is not that large for a pivot table: I have used pivot tables
successfully with over a million records.

If none of your calculated pivot fields contain a division I would check
your data: start by using the pivot filters to reduce the number of records
behind the Div/0 as much as possible, then double-click the Div/0 to drill
down to the records behind.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm