Pivot Tables: Page field in a Combobox in another worksheet

[hsalortb]

Hi,

How can I put (or control) a PAGE FIELD of a Pivot Table in another worksheet in the same MS Excel workbook.

Thanks.

HS

 

[hsalortb]

Andrew,

Aparently the error ocurr when I save the WORKBOOK with 2 COMBOBOX.
When I use only 1 COMBOBOX the error dissapear.

I think the idea is to synchronize both COMBOBOX according to the PAGE FIELDS in the PIVOT TABLE, before save or close the EXCEL WORKBOOK.

What do you think ? How can I do that synchronization ?


Thanks in advance.


HS