XL: Creating Pivot Table from External Data Hangs Computer

Last reviewed: March 27, 1997
Article ID: Q105136
5.00 7.00 WINDOWS kbother kb3rdparty kbtool

The information in this article applies to:

  • Microsoft Excel for Windows, version 5.0
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Query for Windows, version 1.0
  • Microsoft Query for Windows 95, version 2.0

SYMPTOMS

In Microsoft Excel, when you create a pivot table that uses an external data source, Microsoft Excel automatically starts Microsoft Query. In Microsoft Query, once you get your data, you must choose the Return Data To Microsoft Excel command from the File menu or your insertion point will change to an hourglass and you will be unable to continue working.

CAUSE

When you access Microsoft Query through Microsoft Excel, once you have selected and configured your data, you must choose Return Data To Microsoft Excel from the File menu. If you return to Microsoft Excel without performing this action, your insertion point will change to an hourglass and you will be unable to continue working in Microsoft Excel.

WORKAROUND

If you have minimized Microsoft Query but cannot reactivate it (because Microsoft Excel is maximized, for instance), do either of the following to reactivate Microsoft Query:

  • Press ALT+TAB repeatedly until Microsoft Query is activated.

    -or-

  • Press CTRL+ESC, select Microsoft Query, and then choose Switch To from the list of tasks.

Then, either choose Return Data To Microsoft Excel from the File menu, or close Microsoft Query by pressing ALT+F4 or by double-clicking the control menu in the upper-left corner of the Microsoft Query window.

STATUS

This behavior is by design.

MORE INFORMATION

When you create a pivot table that uses an external data source, Microsoft Excel starts Microsoft Query so that you can select and configure the data you want to use. Microsoft Excel then waits for Microsoft Query to return the data and displays the message:

   Waiting for data to be returned from Microsoft Query

You cannot perform any other actions until Microsoft Query returns the data or until Microsoft Query is closed.


KBCategory: kbother kb3rdparty kbtool
KBSubcategory: xlquery

Additional reference words: 5.00 dbf sql stopwatch clock sandglass
Keywords : xlquery kb3rdparty kbother kbtool
Version : 5.00 7.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.