Microsoft KB Archive/69669

{| = Excel Err Msg: Extract Range Is Invalid =
 * width="100%"|

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 &quot;Extract&quot; 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 &quot;Extract&quot; appears, select it and press OK. This should select the range that is defined as the name &quot;Extract&quot;.

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 &quot;Extract&quot; 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.