Why is excel pivot suddenly adding extra columns to my report? 😡

Standard pivotvtable suddenly giving me extra BLANK columns (no headings, no data). How do I remove these? It's infuriating

Copper Contributor

Sep 06, 2023

Laughing at your response!
Nope - definitely no hidden columns. Exact rows & columns selected for pivot.
Maybe a 4th guess at this one??

Diamond Contributor

Sep 06, 2023

IMHO, there is not enough information to make a guesses. Better to have the sample file and how to reproduce, but at least

- on which Excel platform/version you are

- is that cached PivotTable or based on data model or based on Power BI dataset

- is that for any PivotTable (if you build another one on the same source) or for specific one

- what are steps to have such effect

So far as another guess you may try to change her Automatic on None

refresh and return back

Forum Discussion