Show All

Query data for a PivotTable or PivotChart report in the background or while you wait

This setting is not available in reports based on OLAP source data.

1. Click the report.
2. On the PivotTable toolbar, click PivotTable or PivotChart, and then click Table Options or Options.
3. Do one of the following:

   To wait during queries until retrieval is complete, clear the Background query check box.

   To query in the background so that you can continue working in Microsoft Excel, select the Background query check box.

4. To run the query with the new setting, click Refresh Data on the PivotTable toolbar.

   To stop a query that's running while you wait, press ESC. To check on progress or stop a background query, double-click the icon on the status bar to display the External Data Refresh Status dialog box, and then click Stop Refresh.

Note  When you record a macro that includes a query, Microsoft Excel runs the query while you wait. To change the macro to query in the background, use the Visual Basic Editor and change the statement "BackgroundQuery := False" to "BackgroundQuery := True".