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.