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

[CarmelPeinke]

Standard pivotvtable suddenly giving me extra BLANK columns (no headings, no data).

How do I remove these?

It's infuriating 

[#2]

@CarmelPeinke 

First of all, calm down. You may not want to hear it, but Excel is doing what it's programmed to do; you haven't been the victim of something that the Excel demons have decided to visit on you. Far more likely is the probability that you unwittingly have shot yourself in the foot, perhaps with Excel handing you the instrument to carry that out.

From your description, my first guess as to cause would be that you made a change in the array of raw data that this pivot table is summarizing. That would also be my second and third guesses. They may be rows or columns that you've hidden in that raw data, but rows and columns that aren't hidden from Excel.

[#3]

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

[#4]

@CarmelPeinke 

I'm out of guesses. Can you post a copy of the spreadsheet? If not here, then on OneDrive or GoogleDrive, with a link pasted here that grants access.

[#5]

@CarmelPeinke 

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