Can anyone help me with this?
I find I often get stuck on "Preparing the PowerPivotWindow.
Please wait." when I open the Powerpivot window. Not every single time mind you, it;s a little unpredictable.
I am using:
Excel 2010 32 bit connecting to SQL Server 2008R2
MSOLAP CurVer in registry says Version .5.
However the connection string in Excel does not use MOLAP so not sure that matters:
Provider=SQLNCLI10;Data Source=localhost;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=CARVExDB2.0;General Timeout=0
Please share the following detail information to us for further investigation:
Please also provide the Event Viewer logs if the issue happened. Currently, you also try to uninstall and reinstall PowerPivot for Excel add-in to see if this helps.
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?