Pivot Table - Create new file with ONLY certain data - Excel 2003

E

enna49

I have a File with Pivot Table. What I want to do is the selection I have
created, I want to Copy the created sheet with the selected data to a New
File without all the data going with that file. Is this at all possible
eg - I want to send each person the data that is relevant to them without
them being able to select/see the data for everone else.
Thanks
Anne
 
D

Debra Dalgleish

If you send a copy of the full pivot table, the recipient will be able to
view any of the underlying data.

You can copy the pivot table, and paste it as values in a new workbook,
without any of the underlying data. This would provide a snapshot of the
pivot table, but not a working copy.

Or, create a separate pivot table for each person, based on a data source
that contains only their data. This would give them a working copy of the
pivot table, with only their data.
 
Top