Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - Hide the Data Sheet
Hi,
I created a pivot table from a data list. I want to show my client the pivot table, but not the data which i generated the pivot table. Is there a way to just send him my Pivot table, without letting him to know what exactly is in the Data list? (like hiding the worksheet so that he couldnt unhide it?... using a vba?) Thanks very much. Elaine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - Hide the Data Sheet
Once you've made a pivot table, the pivot data is stored in a pivot cache in
the workbook. You can completely remove the data sheet, and the pivot table will be completely functional except for refreshes. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "elaine" wrote in message oups.com... Hi, I created a pivot table from a data list. I want to show my client the pivot table, but not the data which i generated the pivot table. Is there a way to just send him my Pivot table, without letting him to know what exactly is in the Data list? (like hiding the worksheet so that he couldnt unhide it?... using a vba?) Thanks very much. Elaine |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - Hide the Data Sheet
Also, is it able to hide the pivot table field list?
Hi Jon, When I remove the data sheet, all the data in the pivot table disappear. It didnt work. :( Ideally I would just want to send the pivot table to the client so that they can choose from the drop down from the "Drop Page Field" and nothing else... so I would like to hide everything else. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - Hide the Data Sheet
hey Jon!
Its working perfectly!! Its Miracle! Thanks! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - Hide the Data Sheet
Just remember that your client will be able to double-click on the grand
total cell, and recreate all the source data. If you want him to have the summary, but don't want him to have the data, copy the pivot table, and paste it as values in a new workbook. elaine wrote: hey Jon! Its working perfectly!! Its Miracle! Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - Hide the Data Sheet
Some clients might, but probably very few.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Debra Dalgleish" wrote in message ... Just remember that your client will be able to double-click on the grand total cell, and recreate all the source data. If you want him to have the summary, but don't want him to have the data, copy the pivot table, and paste it as values in a new workbook. elaine wrote: hey Jon! Its working perfectly!! Its Miracle! Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - Hide the Data Sheet
oh yes... how do i stop them from retrieving the source data?
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - Hide the Data Sheet
On 12 Mar, 12:08, "elaine" wrote:
oh yes... how do i stop them from retrieving the source data? got it!!! thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to hide data that's less than 1 in a pivot table | Excel Discussion (Misc queries) | |||
How do I hide ungrouped data in a pivot table? | Excel Discussion (Misc queries) | |||
Hide data in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - hide if no data | Excel Discussion (Misc queries) | |||
Hide a data field on a pivot table | Excel Programming |