Hello Excel experts!
Maybe someone encountered this empty columns bug?
I have 6 data fields in my pivot table
When I hide 3-4 of them (i tried both ways: via "fields list" and via VBA "xlHidden") i have this situation: (img attached)
Maybe you know why this happens???
(6 fields are shown OK, hiding 5 of them and showing only 1 also shown OK)
Bookmarks