Pivot Tables - DisplayEmptyColumn question
 

Hello,

I have an OLAP pivot table in Excel. The rows are Customers and the
columns are Products.

Using VBA, I have set DisplayEmptyColumn = True so that all products
are displayed, regardless of whether they have been sold. Then, I
select those products I wish to see and deselect the products I don't
wish to see.

However, when new products are entered into our main database and my
pivot table is refreshed, these new products are automatically
selected. I do not want this automated. I would like to have them
deselected. Is there a way I can modify DisplayEmptyColumn so that I
can make it work the way I want it to?


Any help would be appreciated.

Thanks
H