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.