Pivot table drill down not always working

[LP5609240]

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

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.

[#2]

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").

[#3]

Hello.  I have recently started to have the same issue.  Some cells work some dont and when i get the ones that dont i have to click out of the drill down and go back in and the data is there..very weird.  A fix would be nice.  My updates were up to date.

[#4]

@AckerAckman420 It's still an issue for me. I never found a fix and I'm using the most updated version of everything that I could find :(