Selecting Rows in Pivot Table

[MAB71]

I've created a simple Pivot table in excel 2000 which gets data from an
access db.
The final resulting pivot table has hundreds of rows. The user can uncheck
values to limit the rows but that will take hours if he only wants to see
data for a few rows (which is usual ). Is there a way the pivot table can
start with zero rows ( all row values unchecked ) and let the user select
rows by checking them?

The other option is to drop the row field on the page field but then the
table shows only one record at a time depending on what value is selected
from the page field?

I hope i've made my self clear.

thx

 

[lpolliard]

In the dropdown for row selection the first item is 'Show All',
unchecking this will uncheck all rows. Unfortunately the PT requires
that at least one row be selected so you can't save the file in this
state.

 

[Nick Hodge]

I've sent this for many version releases at beta stage, but had no response.
I believe a 'check all, un-check all' toggle would be great, so.....

answer to your question...no, sorry

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)