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

x
?
Solved

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

Posted on 2011-09-20
4
Medium Priority
?
213 Views
Last Modified: 2012-05-12
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!
0
Comment
Question by:notawahoo2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
andeporter earned 1000 total points
ID: 36567739
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
 

Author Comment

by:notawahoo2
ID: 36569022
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
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 1000 total points
ID: 36573412
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
 

Author Closing Comment

by:notawahoo2
ID: 36601061
I'm splitting the points since there's no apparent way to really do what I asked for. Thanks folks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question