Pivot: where does Excel store the data?

  • Thread starter Thread starter Timo Nurminen
  • Start date Start date
T

Timo Nurminen

Hi all,

when I copy&paste a pivot table into a blank workbook with only one sheet
and then send this workbook to someone by e-mail, the recipient is still
able to drill down into the data by double-clicking a cell in the pivot
table. Excel displays a new worksheet containing the original data.

Where does Excel store the data, and what would be the simplest way to avoid
showing it? Example: the recipient may only see salary totals per
department, not the salaries of individual employees.

Thanks,
Timo
 
Timo,

I'm not the expert on "where" Excel stores the data. But
I do know that Excel does still allow drill down if you
just copy a pivot table to a new location.

However, if you copy the pivot table and then do Edit ->
Paste Special -> Values. The data will be there, but the
drilldown capability will not. Of course all the
formatting from your master pivot table will be gone.
However, you can also do Edit -> Paste Special -> Formats,
and your data will have the "look" of your pivot table as
well.

Hope that helps!

Eric
 

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

Pivot Table Set Up 2
Pivot table drill down data 2
pivot table data 2
Access #Error & Excel Pivot 0
Select and input data from a list 1
Single Filter to change all Pivot Tables in a Workbook 8
Pivot tables - Editing the data source shared by multiple pivot ta 1
Pivot Table Data Source 1

Back
Top