You can't get check boxes in the page field in Excel 2000. To hide items
you can do the following:
In the pivot table, double-click the page field button.
In the PivotTable Field dialog box, there's a 'Hide items' list
Click on an item in that list to hide it.
To see that item again, click on the item in the list, to unselect it.
Click OK to close the dialog box.
ArcticWolf wrote:
I have a Pivot Table with 9 'Page' items. But I can only choose either
'All' or just one from each of the lists. Is there a way to get the 'check
boxes' in the 'Page' part - ie the same as in the 'Row' data please?
I've put the Page items into the Row but this makes my sheet too wide to fit
all the columns on the page.
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com