All PowerPivot options are greyed out


  • I just installed PowerPivot x86 version for 32 bit Windows 7 with Office 2010.  The install went fine but when I open Excel I can see PowerPivot on the ribbon but all the options are grey and they can't be used.
    Saturday, November 20, 2010 7:45 PM


All replies

  • Solved...I had the default workbook type set to Excel 2003 so these options were unavailable.
    keith johnston
    Monday, November 22, 2010 3:01 AM
  • It answers the question, but why do you need to have a xlsx spreadsheat open just to open PowerPivot? 

    Wednesday, March 16, 2011 3:23 PM
  • Thanks Keith! This helped me to solve my issue in Excel 2013, but with a difference.

    I had to change in the Save set of options the "Save files in this format:" option, from "OpenDocument spreadsheet" to Excel Workbook.

    Hope this helps others.



    Monday, November 04, 2013 11:16 AM
  • Thank you. You've helped me as well. I had not saved my Excel workbook as a Excel Workbook.
    Sunday, May 15, 2016 1:46 PM