XL98: Background Query Check Box Not Available

ID: Q178898

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When creating a PivotTable report in Microsoft Excel 98 Macintosh Edition, the Background Query option in the Options dialog box of the PivotTable Wizard is unavailable.

CAUSE

The Background Query option is not available when creating PivotTables.

STATUS

This behavior is by design of Microsoft Excel 98 Macintosh Edition.

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 executing in the background.

The PivotTableWizard method, in Visual Basic for Applications, has a BackgroundQuery property that can be set to True programmatically. However, setting this property to True does not actually allow queries to be performed asynchronously.

REFERENCES

For more information about getting external data using the Query wizard, click the index button in Microsoft Excel Help, type the following text:

query wizard

and then double-click the selected text to go to the "Get external data by using the Query Wizard" topic.

For more information about using queries with PivotTables, click the index button in Microsoft Excel Help, type the following text:

queries, pivottables

and then double-click the selected text to go to the "About creating a PivotTable from an external data" topic.

Additional query words: XL98

Keywords : xlquery xlpivot
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb