How to save Excel 2010 PowerPivoted workbook for user with no connections ?
Posted on 2011-09-20
I've created a workbook with 4 tabs that access a PowerPivot table to get 4 varied sets of data. What is the best way to save a copy of just the "answers" for a user who does not have PowerPivot or access to our back-end SQL Server tables?
I know I can copy-and-paste-values-and-formats into a new workbook, but doing that for all 4 reports seems like more work than I should have to do.