PivotTable - Code returns incorrect values when using a data connecton

Hi,

I am using the following code to get the selected items in a page field:

Please Login or Register  to view this content.

1) when the source data is in the same workbook the code works OK.
2) when the source data is based on a connection, the propertie 'Visible' returns FALSE for every item, despite some of them are selected.

Do you have any idea how I can get around this?


Regards,
Elio Fernandes