You receive an error message when you create a list from a filtered range of cells in Excel 2003 (818244)


The information in this article applies to:

  • Microsoft Office Excel 2003

SYMPTOMS

When you try to create a list from a filtered range of cells in Excel 2003, you receive the following error message:
This operation is attempting to change a filtered range on your worksheet and cannot be completed. To complete this operation, AutoFilters in the sheet need to be removed.

CAUSE

This problem occurs if the range in Excel is filtered and the last row of the range does not appear in the filtered range.

WORKAROUND

To work around this problem, include the first blank row under your filtered range when you create a list.

STATUS

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

MORE INFORMATION

If your filtered range also contains a query table, you receive the following error message first:
Your selection contains one or more query tables. Do you want to convert the selection to a list and remove all query table connections?
This error message is not part of the problem that is described in the "Symptoms" section of this article.

For more information about how to obtain data by using a query, click Microsoft Excel Help on the Help menu, type query table in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about how to filter a range, click Microsoft Excel Help on the Help menu, type filter a range in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about how to create a list, click Microsoft Excel Help on the Help menu, type create a list in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:1/11/2006
Keywords:kbinfo kberrmsg kbprb KB818244 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.