The behavior may appear to be inconsistent between existing files; however, it occurs in any new file you attempt to create in Excel.
Here are some of the formats which may result in this behavior:
- XML Spreadsheet 2003
- Strict Open XML Spreadsheet
- OpenDocument Spreadsheet
The availability of PowerPivot controls is specific to the file type of the active document, depending on whether that file type supports the PowerPivot features.
New, unsaved documents will enable or disable the PowerPivot controls based on the current Save files in this format option setting. If the file is later saved as a file type that supports PowerPivot, the controls on the PowerPivot ribbon will then be enabled.
- From the File tab in Excel, select Options.
- In the Excel Options dialog, select Save.
- In the Save Workbooks section, select Excel Workbook from the Save files in this format dropdown.
If you are currently working in a file that is not the default format, you may need to Save As an Excel Workbook, or open a new workbook before the PowerPivot ribbon controls become available.
33 (51) = Excel Workbook (Excel standard default)
2e (46) = XML Spreadsheet 2003
3d (61) = Strict open XML spreadsheet
3c (60) = OpenDocument spreadsheet