Microsoft KB Archive/277582

= Error message when you use the Lookup Wizard in Excel: &quot;Run-time error '1004' Application-defined or object-defined error&quot; =

Article ID: 277582

Article Last Modified on 1/10/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q277582





SYMPTOMS
When you use the Lookup Wizard to copy formulas and lookup parameters to a new location in a workbook, you may receive the following error message:

Run-time error '1004' Application-defined or object-defined error



CAUSE
This behavior can occur only if the AutoFilter feature is turned on.



WORKAROUND
To work around this issue, first turn off the AutoFilter, and then run the Lookup Wizard. To do this in Microsoft Excel 2002 and in Microsoft Office Excel 2003, point to Filter on the Data menu, and then click AutoFilter. To do this in Microsoft Office Excel 2007, click Filter on the Data tab.

When you have finished using the Lookup Wizard, you can turn the AutoFilter back on.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2002 XL2003 XL2007

Keywords: kbexpertisebeginner kbbug kberrmsg kbpending KB277582

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.