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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pre-configuring Pivot table "views" 4
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Link Drop Down with Pivot Table 2
Pivot Tables by Macro 2
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
Workbook pivot table design function 6
Creating pivot table to Existing worksheet 1
Pivot table help. 2

Back
Top