Microsoft KB Archive/274216

= XL2001: Background Query Check Box Not Available =

Article ID: 274216

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q274216





SYMPTOMS
When you create a PivotTable report, the Background Query option in the Options dialog box of the PivotTable Wizard is unavailable.



CAUSE
Because simultaneous queries are not available in Microsoft Excel, the Background Query option is not available when you create PivotTables.



MORE INFORMATION
If the Background Query option were available, it would allow focus to be returned to Excel (so you could continue to work) while the query is running in the background.

Although the PivotTableWizard method in Microsoft Visual Basic for Applications has a BackgroundQuery property, setting this property to True does not actually allow queries to be performed asynchronously.

