I display a pivot table in a .asp page. The pivot table's data source is a
OLAP cube from SQL server 2000.

I want to give the users the ability to use the "Export to Excel"
functionality within the pivot table for printing purposes.

a. Is there a way from preventing the user to change the filter selection
once in Excel?

b. Is there a way to remove the data from the excel pivot table (once the
"Export to MS Excel" in the pivot table on the asp page has been clicked) so
that when it has been emailed to an external party the pivot table won't
have access to the data source?