Dude, Where’s my PowerPivot workbook?

In homage to Rob Collie’s blog posting style (yes!…he has style, he has grace, …) and of course the movie “Dude, Where’s my Car?”, let’s ask a new question: Dude, where’s my PowerPivot workbook? And before you ask, we’re not talking about searching for the workbook somewhere in your “My Documents” folder, USB drive or SkyDrive.  What we’re referring to here is the fact that you went ahead and saved your PowerPivot workbook to the SharePoint, typically through the Excel Save As or Save to SharePoint function as noted in the posting: Uploading #PowerPivot for Excel workbook using “Save As”…

Rate this:

Ramblings about missing time … and #PowerPivot sneak peek!

Wow, I just checked and its been more than a month since I did my last blog post!  So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But I do have a good excuse!  Really! Oh, and for those of you patient enough to read to the end, I do have an interesting sneak peek for you 🙂 RTM… aaaaaaahhhhhh!! RTM is driving me nuts…but then again, Dave Wickert (PowerPivotGeek) has been handling…

Rate this:

How do I get the menu options for individual reports within the #PowerPivot Gallery?

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! But if I want to modify or view the properties of the individual report – how do I do this?  Well, it’s all about the different views within the PowerPivot Gallery. To change the views go to the Ribbon > Library and under the “Current View” you can change the view of your PowerPivot Gallery (the above is the Carousel view). Choose the Public > All…

Rate this:

Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI

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…

Rate this:

Quick Tips for clearing up space #PowerPivot for SharePoint Uploading

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 SharePoint Server local cache is the c:\windows\temp\WebTempDir.  This folder can fill up real fast so you may want to clear out this folder every so often and/or aim the local cache to…

Rate this:

More great PowerPivot resources!

As you already may know, we have a couple of forums for PowerPivot at: SQL Server 2008 R2 PowerPivot for Excel SQL Server 2008 R2 PowerPivot for SharePoint 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: The Great PowerPivot FAQ where you can see…

Rate this:

Troubleshooting #PowerPivot Excel Services connectivity

You’re on your way to PowerPivot for SharePoint functionality – you’ve uploaded your PowerPivot for Excel workbook to your SharePoint PowerPivot Gallery.  You view the thumbnails of your report and they look nice.   From the thumbnail, you click on the report you want to see, and the report renders nicely.   But then you click on a slicer, and then all of a sudden you get an error like the one below.   What can you do?  Well, for starters, the key thing is to %commonprogramfiles%\Microsoft Shared\Web Server Extensions\14\LOGS\ folder and review the ULS logs which contain a lot…

Rate this: