XL: Error Message: Can Only Copy Filtered Data to Active Sheet (117643)


The information in this article applies to:

  • Microsoft Excel for Windows 5.0
  • Microsoft Excel for Windows 5.0c
  • Microsoft Excel for the Macintosh 5.0
  • Microsoft Excel for the Macintosh 5.0a
  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 95 7.0a
  • Microsoft Excel 97 for Windows
This article was previously published under Q117643

SYMPTOMS

When you use the Advanced Filter feature in Microsoft Excel, you can have the filtered data copied to another location within the same worksheet that contains the list (database), or it can be copied to another worksheet. However, when you attempt to copy the filtered data to a worksheet other than the worksheet that was active when you chose the Advanced Filter option, you may receive the following error message:
You can only copy filtered data to the active sheet.

CAUSE

When you choose the Advanced Filter option from the Data menu, you can only copy filtered data to another location if the destination sheet is the active sheet.

MORE INFORMATION

To copy filtered data to a worksheet other than the worksheet that contains the list, follow these steps:
  1. Select the tab of the destination worksheet.
  2. From the Data menu, choose Filter, and then choose Advanced Filter.
  3. Select the sheet tab of the worksheet that contains the list (database), and select the range of cells in the list (database).
  4. Select the Criteria Range box (which brings you back to the destination worksheet), select the sheet tab of the worksheet that contains the list (database), and select the criteria range.
  5. Select the Copy To Another Location button.
  6. Select the Copy To box and select a cell on the destination worksheet.
  7. Choose the OK button.
The filtered data now populates the destination worksheet based on the database information and the criteria set on the worksheet containing the list.

REFERENCES

"User's Guide," version 5.0, page 407
Modification Type:MinorLast Reviewed:8/16/2005
Keywords:kbualink97 KB117643
©2004 Microsoft Corporation. All rights reserved.