This command requires at least two rows of source data. You cannot use the command on a selection in only one row. Try the following:
If you're using an advanced filter, select a range of cells that contains at least two rows of data. Then click the Advanced Filter command again.
If you're creating a PivotTable report or PivotChart report, type a cell reference or select a range that includes at least two rows of data.
Microsoft Office 2010
Vendor: Microsoft Corporation
Jump to the FaultWire page for Solutions and Fixes for this topic...