PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

Archives

New section called “Troubleshooting”

You might have noticed that I’ve added a new section to my blog called “Troubleshooting” (see here). I have a series of TechEd and internal presentations that I have to prepare for and I thought that sharing the information with you might be interesting. Hopefully you will find it useful. Again, as always, feedback and [...]

“Server Installation” Section is now complete

I have just completed the final two pages for the server installation section of the blog (see here for details). These sections cover:

(3) To install PowerPivot on a new single server with a dedicated DB server, click here. Use this document to install and configure PowerPivot for SharePoint on a single server SharePoint 2010 farm [...]

Changing service accounts and handling password resets

While this is technically a pure SharePoint posting, we have found it useful in our labs. We have password resets all of the time and this cheat sheet was developed to make it as painless as possible. I hope you find it as useful as we do.

Step 1: Start Services.msc

For each service using the machine [...]

Three new ‘Reported Problems’

I have just updated the ‘Reported Problems’ page (http://powerpivotgeek.com/server-installation/reported-problems/) with three new CTP3 reported problems. These have all been fixed in the RTM release.

Excel Services delegation

I am inspired by a recent post from a colleague about the various issues that can come up with Excel Services delegation (see a Denny Lee’s blog here: http://dennyglee.com/2009/11/18/troubleshooting-powerpivot-excel-services-connectivity/) and I wanted to take it a bit further (and maybe a bit ‘geekie’-er)

First, why is this a problem? After all, as you can see in [...]

Best Practices: Ask all of your toughest questions . . .

Denny Lee and I are doing an Academy Live webcast next week on our early PowerPivot best practices. Please feel free to join us!

Registration is at: https://swrt.worktankseattle.com/webcast/3475/preview.aspx

SQL90CALT: A Preview to PowerPivot Server Best Practices

Date: December 15, 2009
Event Start Time: 8:00 AM Pacific Standard Time (UTC – 8 hours)
Duration: 1 hour

Abstract:
This session provides a preview to [...]

PowerPivot demos are now ONLINE

So, you’d like to see what a PowerPivot-enabled workbook likes like? Want to give it a try online using just your browser? Then today is your day. The PowerPivot demos are now ONLINE, see here: http://powerpivot.com/demo.aspx – these are all hosted, and available with just your browser. Now here is a trick that we don’t [...]

A trick: How do I regenerate a thumbnail in the Gallery?

Suppose your thumbnail has gotten out of whack with your workbook. How do you regenerate it? Sure, the brute force way is to re-upload the file again, but surely there must be a geek’er way to do this. Fortunately there is: just edit one of the SharePoint properties for the file. I always select the [...]

Updated “Reported Problems” page

The PowerPivot for SharePoint forum (http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/ ) has just reported several new known problems and their workarounds. I’ve summarized and restructured them a bit in my “Reported Problems” page (http://powerpivotgeek.com/server-installation/reported-problems/). Enjoy.

Why PowerPivot for SharePoint?

From time to time I hear questions and comments from folks questioning why they should purchase the server-side component for PowerPivot. After all, the client software is free (with a Office 2010 Professional license). Why spend the money to invest in the server pieces . . . And because it requires a SQL Server Enterprise [...]