PIVOT TABLE REFRESH PROBLEM

[Ian Digby]

I changed a pivot table page field to "Query external data source as you select each page field item". Now every time I refresh the pivot table, Microsoft Query appears on the taskbar and won't go away until I manually close it.
Does anyone know the reason for this?
Many thanks
Ian Digby