Microsoft KB Archive/61828

{|
 * width="100%"|

Excel: Extracting from a Database on External Worksheet
'Article ID: Q61828

Creation Date: 10-MAY-1990

Revision Date: 04-NOV-1994' SUMMARY

Microsoft Excel versions 2.20 and 3.00 can perform an extract from a database that is located on an external open worksheet.

Once a database and criteria have been defined on the external worksheet, open the worksheet where the extraction is to be performed and do the following:

 From the Formula menu, choose Define Name and type &quot;Database&quot; (without quotation marks) into the Name box. In the Refers To box, type the path to the defined database on the external worksheet. Click OK. For example, if the database is located on a worksheet named &quot;DatabaseSheet&quot;, type &quot;=DatabaseSheet!Database&quot; (without quotation marks). From the Formula menu, choose Define Name again and type &quot;Criteria&quot; (without quotation marks) in the Name box. In the Refers To box, type the path to the defined criteria on the external worksheet. Click OK. For example, if the criteria is located on a worksheet named &quot;DatabaseSheet&quot;, type &quot;=DatabaseSheet!Criteria&quot; (without quotation marks). Enter the database headings into the desired extraction area and perform the extraction by choosing Extract from the Data menu.

MORE INFORMATION

Excel versions 1.50 and earlier do not support this external extraction feature. The Extract command can be used only on the worksheet where the database is defined.

If you try to extract data from a database on an external worksheet with Excel 1.50 and earlier, the error message &quot;Database range is not defined&quot; will be displayed.

To bring extracted data into another worksheet, the Extract command must be performed on the worksheet where the database and criteria are defined and then copied and pasted or linked to the other worksheet.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kbother

KBSubcategory:

Additional reference words: 1.5 1.50 2.2 2.20 3.0 3.00