Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

Pivot tables - just data for one variable?

hi Folks
If I want to send someone a pivot table and only include their data how do I do that? I can quickly get an individual pivot table using Report Filter Pages but how can I send that to someone so they only get their own data - even if they drilldown...I can copy and paste but that seems to lose the formatting...any suggestions/guidelines? Thanks
0
agwalsh
Asked:
agwalsh
  • 3
  • 2
1 Solution
 
regmigrantCommented:
you can save the pivot table without the underlying data (pivot table, design, options, data) which will preserve the formatting but prevents any update of the table including no drill-down.

If you want to retain the pivot facilities but prevent access to some parts of the data then you will have to delete the extra information from the source - is this for a one off or a regular occurrence for a lot of different customers? in which case a macro could manage it for you
0
 
agwalshAuthor Commented:
hi Regemigrant,
I had forgotten about that option that you mentioned which I will pass on. I had thought alright though that they would have to delete the extra information which is what I had said to them...I think for the person concerned it was frustration that they had worked all this data and then couldn't share it effectively. It would be nice to offer them the macro option - that would be great :-)
0
 
regmigrantCommented:
If I can have a look at the data set and an idea on what separates the customers I'll let you know how complex a macro it would be but technically its a new question which might be useful as other experts might have pre-cooked code
0
 
agwalshAuthor Commented:
I checked this out and it turns out that if you turn off the Source Data option, but leave the drilldown turned on. And then copy the sheet to a new book.. It's exactly what I was looking for. Formatting is retained. They just get their own data but they can drill it down. Thanks a million...
0
 
agwalshAuthor Commented:
What would make this excellent would be just the two tweaks I mentioned...turn off the Source Data option, leave the drilldown option on and copy to a new book. But help (as always) much appreciated :-)
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now