PivotTable with Server Page Field Leaves MS Query Application WindowOpen After Refresh.

D

Dave

I created a PivotTable based on a SQL Server view. I'm using Server
Page Fields. 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? 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, possibly using
VBA?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Query Application Window Remains Open After Refreshing PivotTable 1
Pivottable refresh problem 2
Need some PWA help 0
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
Trigger VB code on user selection from Page field in Pivottable 1
SQL Codeing behind a PivotTable 14
Retrieving data in pivottable from Access / SQL server 3
Retrieving data in pivottable (Excel) from Access / SQL server 0

Top