I am using OLAP Cube and setting VisibleItemsList with an array

As expected: it checks the items in the ReportFilter and results are displayed. (My code runs as Macro in Workbook_open)

But the problem is – Once excel is refreshed

1.Any selection (check/unchecking) in JUST THIS ReportFilter ( Any updates in other Report filters… Excel refreshes and updates the results – no issues there)

The MDX Query is UPDATED, the status displays Olap query running and refreshing …. But the results are not updated

..but Pivottable is not refreshing with new results based on Report filter


any idea why Pivottable is not refreshing with new results just for this Report filter selection change?

This is my code in Workbook_open – few lines..

   If (fld.Name = "[UserGroups].[Group Name].[Group Name]") Then

                    pvTable.ManualUpdate = True
                    fld.CubeField.EnableMultiplePageItems = True
                    fld.VisibleItemsList = Array {“a”,”b”}
                End If
                pvTable.ManualUpdate = False
        End If