ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Selection of multiple values for pivot table field (https://www.excelbanter.com/excel-discussion-misc-queries/73447-selection-multiple-values-pivot-table-field.html)

Michael Glenn

Selection of multiple values for pivot table field
 
Hello,

I have a pivot table linked to an OLAP cube. In one of the fields, I have
selected 6 values (out of 100+ values in the list) that I want to include in
the table. This works fine up until new values are added to the cube for
this field. The new values become selected by default for the field, so I
end up with unwanted extra selections and have to go unselect them manually.
is there some way to shut off this "feature"?

Thanks,

Michael


All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com