Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question: SubTotals for 2 of 4 Pivot Tables in same worksheet | Excel Programming | |||
Excel 97 Question (Pivot tables) | Excel Discussion (Misc queries) | |||
Pivot Tables - "simple" question | Excel Discussion (Misc queries) | |||
Question about Pivot Tables..why is that | Excel Discussion (Misc queries) | |||
Question About Pivot Tables | Excel Programming |