Excel Err Msg: Extract Range Is Invalid

 Last reviewed: November 4, 1994
Article ID: Q69669
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0

SUMMARY

If you highlight a range of titles that were copied from the database titles and select Extract from the Data menu, you may get the error message: 

   Extract range is invalid

Solution

  1. From the Formula menu, choose Define Name.

  2. Delete the name "Extract" from the List Of Names in the Define Name dialog box.

MORE INFORMATION

This error occurs when an extract range has been set and the cells that the extract range refers to do not contain valid titles. Excel is attempting to perform the data extract somewhere else on the Worksheet, rather than using the cells you have selected.

Another way to verify this is to choose Goto from the Formula menu. If the name "Extract" appears, select it and press OK. This should select the range that is defined as the name "Extract".

When you choose Extract from the Data menu, Excel first looks to the list of defined names in a worksheet to see if the name "Extract" has been defined. If it does not find this defined name, it defaults to the currently selected area.

By deleting this name, you will be forcing Excel to use the area you have selected for the Extract range.

REFERENCES

"User's Guide 1," version 4.0, pages 340-342 "User's Guide," version 3.0, pages 380-384

KBCategory: kberrmsg
KBSubcategory:

Additional reference words: 3.0 3.00 err msg

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: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.