PowerPivotGeek?

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

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 [...]

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 [...]

What is 1/2 a day lost over Thanksgiving worth?

If you are going to change a server’s static IP address after you have installed SharePoint 2010, please remember to reboot the server to make the new address become recognized. An ‘iisreset’ isn’t good enough. Otherwise you will lose 1/2 a day of your life trying to debug it. “When in doubt, reboot” is my [...]