Pivot Table Page Field
I have a Pivot Table connected to external data (SQL Server Cubes). I have
some page fields on the pivot. The page fields allow users to select multiple
items. There is a checkbox that says "Select Multiple Items" in the page
field drop down. If you uncheck that users cannot select multiple items under
the page field. I want to disable this checkbox that allows users to select
multiple items in the page field. Can it be done through VBA?.
|