Selecting Rows in Pivot Table
 

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

Selecting Rows in Pivot Table
 

This will give you what you need. It unchecks all row
items in the Pivot row field 'rowFieldName' except the
first row item (a minimum of 1 item must be visible). the
suer can then go back into the Pivot table layout and
check additional row names as required.

Sub uncheckPivotRows()

Dim i As Long

For i = ActiveSheet.PivotTables(1).PivotFields _
(rowFieldName).PivotItems.Count To 2 Step -1
ActiveSheet.PivotTables(1).PivotFields _
(rowFieldName).PivotItems(i).Visible = False
Next

End Sub

hth,

TonyM

-----Original Message-----
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




.

Selecting Rows in Pivot Table
 

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
HIS


"MAB71" wrote in message
...
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