XL2001: Background Query Check Box Not Available (274216)


The information in this article 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.

REFERENCES

For more information about how to get external data by using the Query Wizard, follow these steps:
  1. On the Help menu, click Contents and Index, click Index, and then click Q.
  2. Scroll down until you locate query, and then click the arrow to the left to view a list of topics under the general topic.
  3. Click Get external data by using the Query Wizard.
If you cannot find the information that you want, ask the Office Assistant.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbprb KB274216
©2002 Microsoft Corporation. All rights reserved.