Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
I have a pivot table linked to an access file for it's data. I would like to
send the pivot table out to other people, but they do not have permision to see the data in the access data base. I would still like to have the functionality of the pivot table, but not link it to the db (I would like to be able to sort and filter). Any ideas? thanks! Robert |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
Is there a worksheet with the access data on it, or you creating the pivot
table directly from access? If you have a worksheet you can do an xlVeryHidden... if not there's definitely programming methods for not allowing people to view that information. "Robert_DubYa" wrote: I have a pivot table linked to an access file for it's data. I would like to send the pivot table out to other people, but they do not have permision to see the data in the access data base. I would still like to have the functionality of the pivot table, but not link it to the db (I would like to be able to sort and filter). Any ideas? thanks! Robert |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
For the pivot table to have sorting and filtering functionality, it
would need to have the pivot cache with records from the database. You could add protection to the pivot table, to prevent some actions, but users could crack the protection and double-click on a cell in the pivot table, and see the underlying data. Robert_DubYa wrote: I have a pivot table linked to an access file for it's data. I would like to send the pivot table out to other people, but they do not have permision to see the data in the access data base. I would still like to have the functionality of the pivot table, but not link it to the db (I would like to be able to sort and filter). Any ideas? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |