I don't seem to be able to autofilter results in a PIVOT table (eg to show
exceptions, say non zeros). I certainly could do this in Office97 (and I
think in other Office versions in between). Do I have some setting turned
on/off that shouldn't be, or has this functionality been discontinued for
some reason.

You can show or hide specific items in the row and column fields, and
you can show a specific number of top or bottom records.

Do you remember how you filtered the records in Excel 97?

Andrew_SE13 wrote:
I don't seem to be able to autofilter results in a PIVOT table (eg to show
exceptions, say non zeros). I certainly could do this in Office97 (and I
think in other Office versions in between). Do I have some setting turned
on/off that shouldn't be, or has this functionality been discontinued for
some reason.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I have figured out (stumbled across) how to do it now. If you select only
heading cells inside the pivot table (all or some of them) then the
autofiltering option in the data menu is greyed out - however, if you include
at least one heading cell, even if blank, outside the pivot and all the
pivots heading cells it is available again and filtering seems to work
normally as it would with an ordinary list. I don't think it was necessary to
do this in 97 or presumably I would have come across this problem before.

"Debra Dalgleish" wrote:

You can show or hide specific items in the row and column fields, and
you can show a specific number of top or bottom records.

Do you remember how you filtered the records in Excel 97?

Andrew_SE13 wrote:
I don't seem to be able to autofilter results in a PIVOT table (eg to show
exceptions, say non zeros). I certainly could do this in Office97 (and I
think in other Office versions in between). Do I have some setting turned
on/off that shouldn't be, or has this functionality been discontinued for
some reason.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Excel 97 has the same limitation. The active cell must be outside the
pivot table in order to apply an AutoFilter.

Andrew_SE13 wrote:
I have figured out (stumbled across) how to do it now. If you select only
heading cells inside the pivot table (all or some of them) then the
autofiltering option in the data menu is greyed out - however, if you include
at least one heading cell, even if blank, outside the pivot and all the
pivots heading cells it is available again and filtering seems to work
normally as it would with an ordinary list. I don't think it was necessary to
do this in 97 or presumably I would have come across this problem before.

"Debra Dalgleish" wrote:


You can show or hide specific items in the row and column fields, and
you can show a specific number of top or bottom records.

Do you remember how you filtered the records in Excel 97?

Andrew_SE13 wrote:

I don't seem to be able to autofilter results in a PIVOT table (eg to show
exceptions, say non zeros). I certainly could do this in Office97 (and I
think in other Office versions in between). Do I have some setting turned
on/off that shouldn't be, or has this functionality been discontinued for
some reason.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Can I keep the autofilter to the pages created when I use "show pages"? I
tried but didn't work.

"Debra Dalgleish" wrote:

Excel 97 has the same limitation. The active cell must be outside the
pivot table in order to apply an AutoFilter.

Andrew_SE13 wrote:
I have figured out (stumbled across) how to do it now. If you select only
heading cells inside the pivot table (all or some of them) then the
autofiltering option in the data menu is greyed out - however, if you include
at least one heading cell, even if blank, outside the pivot and all the
pivots heading cells it is available again and filtering seems to work
normally as it would with an ordinary list. I don't think it was necessary to
do this in 97 or presumably I would have come across this problem before.

"Debra Dalgleish" wrote:


You can show or hide specific items in the row and column fields, and
you can show a specific number of top or bottom records.

Do you remember how you filtered the records in Excel 97?

Andrew_SE13 wrote:

I don't seem to be able to autofilter results in a PIVOT table (eg to show
exceptions, say non zeros). I certainly could do this in Office97 (and I
think in other Office versions in between). Do I have some setting turned
on/off that shouldn't be, or has this functionality been discontinued for
some reason.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I think you'll have to add it to each of those pages.

Angus wrote:

Can I keep the autofilter to the pages created when I use "show pages"? I
tried but didn't work.

"Debra Dalgleish" wrote:

Excel 97 has the same limitation. The active cell must be outside the
pivot table in order to apply an AutoFilter.

Andrew_SE13 wrote:
I have figured out (stumbled across) how to do it now. If you select only
heading cells inside the pivot table (all or some of them) then the
autofiltering option in the data menu is greyed out - however, if you include
at least one heading cell, even if blank, outside the pivot and all the
pivots heading cells it is available again and filtering seems to work
normally as it would with an ordinary list. I don't think it was necessary to
do this in 97 or presumably I would have come across this problem before.

"Debra Dalgleish" wrote:


You can show or hide specific items in the row and column fields, and
you can show a specific number of top or bottom records.

Do you remember how you filtered the records in Excel 97?

Andrew_SE13 wrote:

I don't seem to be able to autofilter results in a PIVOT table (eg to show
exceptions, say non zeros). I certainly could do this in Office97 (and I
think in other Office versions in between). Do I have some setting turned
on/off that shouldn't be, or has this functionality been discontinued for
some reason.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



--

Dave Peterson