Pivot Table No Longer Picking Up Data

[JakeMann]

Hi All,

I have a pivot table that up to last week has been working fine.

I've double checked the data source and even deleted the table and reinstated it, but I'm still missing data. Nothing is filtered. I've refreshed. I can't see what problem it could be.

I have a slicer in place and all the correct data is showing when I don't have the slicer on. But I really could do with it!

Any ideas?

[oeldere]

Reading your question, it would be something with the slicer.

But without seeing your data it is hard to tell (test), at least it is for me.

[JakeMann]

Hi,

I've attached the spreadsheet.

The table in question is under Production Requirements Update and is the table under Tooling Movements.

The slicer is selecting all the tools it needs to but if you select 12828 for example, it's not pulling though all the data.

[oeldere]

I get a failure making a new pivot table.

This workbook contains a pivot table which is made in a version before 2013.

[JakeMann]

Not a problem. I simply deleted the slicer and reinstated it and it's no working. Must have been a gremlin.