January 15, 2010 by dennyglee
When you start playing with the PowerPivot Gallery, some of you will be enamored by the various views of the Silverlight control included as part of the PowerPivot Gallery – I know I was!
Archive for January, 2010
How do I get the menu options for individual reports within the #PowerPivot Gallery?
Published January 15, 2010 Usage Leave a CommentTags: FAQ, SharePoint
So i requested a PowerPivot workbook from SharePoint, what happens?
Published January 12, 2010 Configuration , Internals Leave a CommentTags: Excel Services, SharePoint
In my previous blog posts we made use of a published PowerPivot workbook to use a datasource. In this post we are going to discover what goes on under the hood when you call a PowerPivot workbook on a SharePoint 2010 server.
Note from Denny: While Kasper has his own excellent blog, I thought it would be nice to reference his blog posting at PowerPivotTwins.com since its a great quick read to explain what happens. Enjoy!
Uploading #PowerPivot for Excel workbook using “Save As” vs. SharePoint UI
Published January 6, 2010 Configuration Leave a CommentTags: Excel, SharePoint, Troubleshooting
When you save a PowerPivot for Excel workbook by using the “Save As” function with Excel, this will use the Office Upload Center as its mechanism to save the file. This is different than uploading the file by using the SharePoint UI as the SharePoint UI uses a different mechanism via http to upload the file than the Office Upload Center. The Office Upload Center is included as part of Office 2010 and what is great about this feature is that you can save the file asynchronously. What this means is that you can save the file and then continue to work with your Excel file in the mean time. With the SharePoint UI, once you upload the file it is locked and you cannot work with the file until the upload has been completed. Though, based on current sets of tests, the upload via SharePoint UI is faster than the upload via Office Sync Center so there is the balance between whether you want to work with the file asynchronously or do you want to have faster upload.
To perform an Excel “Save As”, you need only to click on “Save As” within the File option of the Office Ribbon and specify the PowerPivot Gallery of your SharePoint site.
Quick Tips for clearing up space #PowerPivot for SharePoint Uploading
Published January 6, 2010 Configuration Leave a CommentTags: SharePoint
When you upload your PowerPivot for Excel workbook to your PowerPivot enabled SharePoint site, you typically will deal with much larger files than your other SharePoint sites. This is the reason why we suggest that you increase the Excel Services and SharePoint to the max file sizes allowed (to do this, follow Step 18 at http://powerpivotgeek.com/server-installation/existing-farm-install/).
Saying this, there are some other quick tips as well:
The Great PowerPivot FAQ!
Published January 6, 2010 Perspectives Leave a CommentTags: Troubleshooting
Just in case you’re not already aware of this, some of great contributors to the PowerPivot community are now adding and moderating to the Great PowerPivot FAQ. Please check it out and email us your questions as well!
Enjoy!
More great PowerPivot resources!
Published January 6, 2010 Uncategorized Leave a CommentTags: Configuration, SharePoint, Video
As you already may know, we have a couple of forums for PowerPivot at:
Dave Wickert with his PowerPivotGeek.com site has also created two new sections:
- Reported Problems section which compiles the different issues concerning PowerPivot for SharePoint installations and
- Troubleshooting section which complies different Troubleshooting issues concerning PowerPivot for SharePoint installations.
Please do not forget that the all four PowerPivot for SharePoint installation guides can be found here as well.
Rob Collie has also put together:
where you can see some of the key MVPs respond to some great questions concerning PowerPivot …disclosure: myself and Dave are also answering questions there 
The coup de grace of course is is Dave and my downloadable Academy Live presentation which
This will definitely help jump start your PowerPivot for SharePoint geekiness.
Enjoy!
[Originally posted at dennyglee.com]
