Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.

This article was previously published under Q277582

↑ Back to the top


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

↑ Back to the top


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

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top

Keywords: KB277582, kbpending, kberrmsg, kbbug, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 277582
Revision : 4
Created on : 1/10/2007
Published on : 1/10/2007
Exists online : False
Views : 193