<div>
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.
</div>


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.

<div>
I'm splitting the points since there's no apparent way to really do what I asked for. Thanks folks!
</div>


I'm splitting the points since there's no apparent way to really do what I asked for. Thanks folks!

<div>
<div class="content wysiwyg-content">
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 &quot;answers&quot; for a user who does not have PowerPivot or access to our back-end SQL Server tables?<br />
<br />
I know I can copy-and-paste-values-and-<wbr />formats into a new workbook, but doing that for all 4 reports seems like more work than I should have to do.<br />
<br />
Thanks!
</div>
</div>


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!

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.