I created a PivotTable based on a SQL Server view. After refreshing
the PivotTable, an MS Query application window opens and remains open
even after the PivotTable is refreshed. Normally, when refreshing a
PivotTable based on a SQL Server view, I do not see the application
window open or remain open afterward. Any ideas what is causing this
to happen?

Thanks,

Dave

On Nov 29, 2:20 pm, Dave wrote:
I created a PivotTable based on a SQL Server view. After refreshing
the PivotTable, an MS Query application window opens and remains open
even after the PivotTable is refreshed. Normally, when refreshing a
PivotTable based on a SQL Server view, I do not see the application
window open or remain open afterward. Any ideas what is causing this
to happen?

Thanks,

Dave


A little more specific information related to my post above. This only
happens when using server page fields. I selected Field Settings on
the one page field I had, chose Advanced, and then chose the "Query
external data source as you select each page field item (requires less
memory) option.

If this is a bug in Excel, does anyone know how I could have MS Query
automatically close after the PivotTable is refreshed?