Microsoft KB Archive/69667

{| = Data Extract Will Not Use Highlighted Area in Excel =
 * width="100%"|

Last reviewed: November 3, 1994

Article ID: Q69667 The information in this article applies to:
 * Microsoft Excel for Windows versions 3.0, 4.0

SUMMARY
When you highlight a range of database titles and select Extract from the Data menu, the Extract dialog box prompts you for unique records only. However, when you choose OK, nothing happens.

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 behavior occurs when an extract range has been set. Microsoft Excel is performing a data extract somewhere else on the worksheet, using a defined name for the range of database titles.

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

When you choose Extract from the Data menu, Microsoft 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 Microsoft Excel to use the area you have selected for the Extract range.