Missing Pivot Data in Pivot Page Field (PF)-Weird!

Dear All,

Does anyone have an idea of why this happens. It's not often but sometimes.

This will be the first time after almost a year now. (had it like less than
5 times over 5 year)

My database is intact with every column and row filled with data.

No. of Rows: 2,400++
No. of Columns: 60++

This is what is missing:

Pivot Page Field is a list of bill no. from the database Column A (the most
primary column)


Pivot Page Field - Inv-No:
a) SM-06-30983
b) SM-06-30984 <----- this is missing (not even in the list), WEIRD
c) SM-06-30985

The other Pivot Tables are working except for this one particular Pivot Table.


So I Troubleshoot--- Database (but didn't work)

1. I have gone through the database structure
2. Re-typed the whole thing.
3. Copy Paste Special Value
4. Used Macro (Debra D's Change Pivot Field to force it out)
5. Used SM-06-30983 information and change to SM-06-30984
6. Change 1 of the 6 SM-06-30985 data line to SM-06-30984
7. Refresh like more than a million times.
8. Searched the advance list (hide list)
9. Look at the forum for a solution.


I just don't know if I wanna cry or laugh!!!


The only way I know is to rebuilt the Pivot Table AGAIN!!!

I was thinking of not to coz this pivot table is an invoice document with
lots of stuff. (rebuild is the last option)


If anyone has an idea and experienced of how to trouble shoot and retrieve
the data, that is a great cause.

Thanks all!!!
I am on the XLS 2000.