PowerPivot button grayed out for existing .xlsx files RRS feed

  • General discussion

  • Hi,

    I have been working with PowerPivot in Excel 2010 for some time now with no issue till this morning when any existing report (.xlsx) file does not allow me to go to the PowerPivot window (grayed out mostly. sometimes it shows up and when I click it the PowerPivot window opens up and gets stuck with a message ' Preparing the Power pivot window .. please wait'). The field list is grayed out too and I am not able to add any new pivot table or chart. Existing slicers are all working. Also new .xlsx files are working (able to open PowerPivot).

    I reinstalled Office and the PowerPivot add on, tried to disable/enable add on in Excel -> Options and made sure it is not in the 'Disabled' list.

    I just tried on a different computer and faced the same problem there too.

    Appreciate any help or ideas you can provide.

    I am using PowerPivot Version 11.0.3000.0 and Excel version 2010 14.0.6023.1000 (32 bit).



    Saturday, July 12, 2014 1:55 AM

All replies