Pivot table fields expands automatically when updating data (only where data has been changed)

[Ottar]

Hi,

I have created a pivot table that is connected to an input sheet with data. The input sheet retrieves data automatically from a external source through an add-in to Excel. When updating data the fields expands, but only for the items which have been changed. I want the table to be updated automatically, but not the fields expand automatically. Is there any pivot options to prevent this problem?

It should be mentioned that the pivot table is not directly connected to the input sheet (which is updated from the external source), but from a "help-sheet" reflecting the input sheet with some additional columns. I use conditional formatting and name range in the pivot (I guess that shoudnt matter)

Hope I managed to explain the problem sufficient.

Best regards,

Ottar

 

[aaronglover]

Hi,

I have created a pivot table that is connected to an input sheet with data. The input sheet retrieves data automatically from a external source through an add-in to Excel. When updating data the fields expands, but only for the items which have been changed. I want the table to be updated automatically, but not the fields expand automatically. Is there any pivot options to prevent this problem?

It should be mentioned that the pivot table is not directly connected to the input sheet (which is updated from the external source), but from a "help-sheet" reflecting the input sheet with some additional columns. I use conditional formatting and name range in the pivot (I guess that shoudnt matter)

Hope I managed to explain the problem sufficient.

Best regards,

Ottar

Sorry for the thread res here but did you ever find a solution to this? I have been investigating this exact same issue and cannot find a solution, it is very annoying. I am going to have to add some VBA code to automatically collapse all of the fields if I cannot find a way to disable this stupid "auto expand new data" thing.

Thanks!