Pivot table drill down not always working

Occasional Visitor

Hi,

I have a pivot table that I often double click values to display drill downs. Recently, some of them open up in a new tab but there isn't any data there. If I go to a new tab and then come back to it, it reappears. I can't seem to figure out why. It's the same values that don't work each week. Not a huge deal to go to a new tab and coming back, but would love to not have to deal with it.

 

Warehouse A gives me problems every week - I double click and this happens

 

LP5609240_2-1662489901494.png

 

 

LP5609240_1-1662489768006.png

 

When I move to a new tab and come back, all of the blank columns have the correct information displayed. Other warehouses work totally fine - Warehouse K opens as normal.

1 Reply

Hi @LP5609240,

 

as far as I know, there was a display issue in Microsoft 365 that shoud be fixed already.

If you use Microsoft 365, maybe you need to update Excel to the latest build (Menu "File | Account | Office Updates").