Mysterious Item in a pivot table field


Posted by George on November 15, 2000 12:11 PM

I have a field (company name) and if I choose "show items
with no data" in the option area i get a company which is
not even in the pivot table range.

It used to be in a previous version but it has been deleted.
And yes i have refreshed the data.

I am trying to keep the pivot tables the same size when
the page field is changed. I understand i should get companies
which aren't invlolved in one of the page choices but this phantom
company confuses me.

I know i can go in and hide it but I am not sure why it is there
in the first place and don't want to have to hide multiple phantom companies.

any thoughts would be appreciated

thanks



Posted by THOMAS VENN on November 17, 2000 11:30 AM

It sounds like your pivot table is still thinking it is the old data you are working with. a couple of things you can do. One is to create a new pivot table based on the data you know to be correct. the second method is to check what data you have. the way to check what raw data your pivot table is using is by going to the very last cell of the pivot table (very last cell in lower right hand corner of the pivot table), and double click on that last cell. when you do that, a new sheet will appear with all the data that was used to create the pivot table.

cheers,

thomas