Creating a pivot table in excel 2000

[slinkyjib]

At home I have Excel 2003, and have been working on a pivot table. The table counts data from a spreadsheet..(not to hard). On excel 2003, on the drop down box in the table I can tell the table not to count blanks and 0's.

When I try to do this in Excel 2000,( which is what I have in the office), the drop down box disappears, and I get the message "to many unique identities".

I need this table to work..

I am basically trying to count numbers against a value, but there are about 45000 numbers (including blanks), and about 30 values.

The totals for each value are ok, I have these in another table. but in the feeding spreadsheet, I have a formula to take out duplicate numbers. So I need to be able to tell the pivot table to not count 0's and blanks, otherwise I just get totals with duplicates.

Hope fully this makes sense to you guys.

 

[Andrew Poulsom]

In Excel 2000 there is a limit of 8000 items in a PivotTable report. It must have been increased in Excel 2003.

 

[slinkyjib]

yeh, it was increased to about 30000.

But, all I need is to use some sort of filter in the pivot table.
The drop down box in 2003 acts as a filter.

Was kinda hoping there was some kind of filter in 2000, that would solve the problem.