Pivot Items showing items that don't exist in data source

[Greenjelly]

I googled this but couldn't find a suitable answer,

I have linked to a access table from excel via pivot table, however the pivot items show more items within the drop down list then there is present in the source data to which I have linked to.

These arn't fictional items, in that the do exist in other tables within the access db, but not the on I have linked to

Does anybody have any ideas about what is going on and how i might rectify the situation

Opening a brand new spreadsheet and recreating the pivot table solves the problem, but I rather no do this

 

[Peter Thompson]

I think I read something about this before you could try taking the field with the additional items out of the pivot table, refreshing the table and then re-inserting the field into the table and refreshing again.

 

[RoryA]

Does this page help?

 

[Greenjelly]

That's the ticket - cheers

 

[mdjbags]

Taking the data out of the table didn't work for me. I took data out, refreshed and it looked ok, but as soon as I put the data back in, the same symptoms came back. I had done a find/replace on some of the data within the pivot table and then I experienced the same symptom as the original post. I know the data intersections were false, so I searched more and found this solution worked for me:

1. Right-click a cell in the pivot table
2. Click on PivotTable options
3. Click on the Data tab
4. In the Retain Items section, select None from the drop down list
5. Click OK, then refresh the pivot table

 

[scottsturf]

Taking the data out of the table didn't work for me. I took data out, refreshed and it looked ok, but as soon as I put the data back in, the same symptoms came back. I had done a find/replace on some of the data within the pivot table and then I experienced the same symptom as the original post. I know the data intersections were false, so I searched more and found this solution worked for me:

1. Right-click a cell in the pivot table
2. Click on PivotTable options
3. Click on the Data tab
4. In the Retain Items section, select None from the drop down list
5. Click OK, then refresh the pivot table

That did the trick. Thank you!