Microsoft KB Archive/110436

Microsoft Knowledge Base

XL: Returning Data from Query May Overwrite Cell Data

Last reviewed: March 27, 1997
Article ID: Q110436

5.00 7.00 | 5.00 5.00a

WINDOWS     MACINTOSH

kbusage

The information in this article applies to:

• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SUMMARY

In Microsoft Excel, when you use Microsoft Query to return data to a worksheet from an external data source, you may not be prompted that existing data is about to be overwritten.

MORE INFORMATION

If the selected cell or range contains data that is part of a previously defined query definition, you will be prompted to replace the query definition. However, if the selected cell or range contains data that is not part of a query definition, the returned query data will overwrite any data in that range.

The only exception to this situation occurs if there is an array in the range. If there is an array in the range, you receive the following message:

   The range in which the data will be placed contains part of an array or
   locked cells.

In this case, your only choice is to choose OK, and the operation is canceled.

KBCategory: kbusage KBSubcategory: xlquery kbtool Additional reference words: 5.00 7.00 Keywords : kbtool xlquery kbusage Version : 5.00 7.00 | 5.00 5.00a Platform : MACINTOSH 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 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.