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