Installing SSAS 2008R2 SP1 breaks PowerPivot

Here’s something I found out a few weeks ago, just before I went on holiday: installing SP1 for SSAS 2008R2 breaks a PowerPivot installation on the same machine. After I’d installed SP1 on my laptop I found I got an “Unable to open file” error message in PowerPivot whenever I tried to import data, at which point PowerPivot crashed. For me the fix was easy – reinstall PowerPivot and it worked again – but I’m glad I found this out before I needed to use PowerPivot in front of a customer.

8 responses

  1. I’ve just found out that reinstall the old version of PowerPivot doesn’t solve the problem. I have to download the latest version of PowerPivot (version 10.50.2500.0, matched to SP1 build number) and reinstall with it.

Leave a Reply to Ayyappan Thangaraj Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: