Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Okay, so I'm primarily an Access/Web developer, but a client has asked us to use Microsoft Access to automatically set filter values on their Excel PivotTables. This has been going okay until I hit a snag. Most of the filters are single value - meaning there is a drop-down list of (All), Value1, Value2, etc. However, there are a couple which are multi-select. There is a drown down list, and instead of selecting one of the items, you can click on a little checkbox to select 1-many of the items. I need to figure out how to set THESE items programmatically. Any ideas? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PivotTable Drop-Down Un-Checked Item Missing | Excel Worksheet Functions | |||
Data values WON'T DELETE in PivotTable drop-downs | Excel Discussion (Misc queries) | |||
Excel 2000 / How clear drop-down list in Pivottable? | Excel Programming | |||
Dynamic Selection of Pivottable Drop Down Items | Excel Programming | |||
Help - PivotTable Drop-down not Sorting | Excel Programming |