Pivot Tables - Label Filters 'greyed out'

[Jon Johny]

I constructed a simple pivot table on sperate sheet based on info on another sheet. One problem I ma having is the 'Label Filter' is greyed out.

Does this have something to do with the fact that some rows on my data sheet are hidden? As well how can I unhide these hiddne rows, since highlighting and then clicking unhide does not unhide these rows. These rows are not groued either, so there is no plus or minus sign next to them to click.

Th only way I can unhide the rows is by manually dragging the row above it. This unhides 1 row at a time, this sheet has thousands of rows.

Any help is appreciated.

 

[millhouse123]

Not sure about the pivot table but it sounds like your rows might have just been resized. Does it help to select them all, right click and set row height to 15?

 

[Jon Johny]

No, resizing does not help? Any idea what this is?