General information
Category:
COM/DCOM and OLE Automation
Title:
Page Refresh in Excel Pivottable?
Let's say I have two comboboxes in the page area of an Excel 2000 pivottable.
The top combobox named states is the list of 50 states and the lower combobox
named 'cities' is a list of major cities for each state.
What I'd like to see happen is to only show the cities associated with their state when a specific state is selected. I know that the comboboxes work as filters, but a user has asked if this type of functionality can be made to work inside of a pivottable.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only