posted 1/28/2012 by CraigLove - Views: [412]
Recently I was conducting an unscheduled demonstration of PowerPivot and had one of those uh-oh moments. After I extolling the virtues of this cool tool, I launched Excel and clicked the PowerPivot Window button. I could almost hear the sad trombones playing "Wah Wah Waaaahhh...." as a command window popped up with a message similar to "Unable to open file ... Files\Microsoft Analysis Services\AS OLEDB\10\FlightRecorderCurrent.trc".
Ah, the joys of unscheduled/unrehearsed demonstrations!
"Not a problem!", I said. "I have been messing with my laptop and must have misconfigured the hoozywatsy. I will simply uninstall and reinstall PowerPivot! You see the download can be found at www.PowerPivot.com. ..."
After a few moments and a relaunch of Excel.... "Wah Wah Waaaahhh...."
The fix for me was found on this msdn article:
http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/2620e183-31e9-42b9-8191-cee953cf0990
As mentioned in the article, in addition to uninstalling PowerPivot I had to delete/rename the "C:\Program Files\Microsoft Analysis Services". After another reinstall, all was well.
Just wanted to pass this along! Happy pivoting.
Craig