Pivot table Help Excel 2007

[Yossy]

Is there a way I can Hide some data in Pivot table.

I have 3 Rows of column that I pivot but I want only one row to show without
anyone having access to the filter option in the "Value field setting Menu".
I use Excel 2007 please all help totally appreciated.

Also can I put 2 pivot tables in one worksheet? Please let me know if I can
and how to do this.

Thanks a Big Bunch.

 

[Shane Devenshire]

Hi,

I'm not sure what "I 3 rows of column means"?

You can hide any row in Excel by right-clicking the row number and choosing
Hide.

You can protect the spreadsheet so that the user can't use any part of the
pivot table, only view it. But you can't just disable a filter.

You can put as many pivot tables into one sheet as you want. When you click
Insert, Pivot Table, choose Existing Worksheet and click in the Location box
and click the sheet tab and cell address where you want to put the pivot
table.

If this helps, please click the Yes button,

Cheers,
Shane Devenshire