Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 127
Default Pivot table Help Excel 2007

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default Pivot table Help Excel 2007

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

"Yossy" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create pivot table from existing pivot table in excel 2007 Udayraj Dhulekar Excel Discussion (Misc queries) 2 July 8th 13 08:22 PM
Pivot Table in Excel 2007????? OldManEd New Users to Excel 4 July 9th 08 12:49 AM
Pivot Table in Excel 2007 OldManEd New Users to Excel 3 July 1st 08 07:41 PM
Excel 2007 - Pivot Table Anna_Stephanie Excel Discussion (Misc queries) 2 April 23rd 08 03:34 PM
Pivot Table in Excel 2007 : Problem with % in Table spudsnruf Excel Discussion (Misc queries) 2 January 9th 08 10:53 PM


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"