none
Preparing the PowerPivotWindow freeze

    Question

  • 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

    Monday, November 18, 2013 1:03 PM

Answers

  • Hi Puzzled,

    Please share the following detail information to us for further investigation:

    • Operating System information.
    • RAM information.
    • PowerPivt data model data.

    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.

    Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, November 19, 2013 1:14 PM