Pivot Table

[Guest]

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

 

[Guest]

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.

 

[Debra Dalgleish]

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.