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
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
A little background as to how I came to I design this code:
Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…