Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Distributing Pivot Tables where pivot table data can't be accessed
How can I circulate pivot tables to other team members without allowing them
to either see or tamper with the underlying database? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Distributing Pivot Tables where pivot table data can't be accessed
Excel isn't really designed to be secure. You could put the pivot table in a
different workbook than the original data, or delete the data sheet after creating the pivot table. However, all one has to do to recreate the original data table is to apply row and column totals to the pivot table, then double click on the grand total cell to output all records of the data into a new worksheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bendinblues" wrote in message ... How can I circulate pivot tables to other team members without allowing them to either see or tamper with the underlying database? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) |