How to save Excel 2010 PowerPivoted workbook for user with no connections ?

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.

Thanks!
notawahoo2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
andeporterConnect With a Mentor Commented:
I'm not 100% sure I understand your question but you could try printing them to a .pdf file using CutePDF or a similar program.
0
 
notawahoo2Author Commented:
I'd like to send a vanilla Excel workbook to the user, with the data in cells so it can be sorted and summed, but leave out the pivot and data connection functionalities.
0
 
Rory ArchibaldConnect With a Mentor Commented:
I'm not sure there are any other options if you don't want to send the live pivot. (they can still use it without PowerPivot).
0
 
notawahoo2Author Commented:
I'm splitting the points since there's no apparent way to really do what I asked for. Thanks folks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.