If the file is later saved as a file type that supports PowerPivot, the controls on the PowerPivot ribbon will then be enabled. New, unsaved documents will enable or disable the PowerPivot controls based on the current Save files in this format option setting. 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. Here are some of the formats which may result in this behavior: This behavior can occur if the Save files in this format option is set to a file format other than the default Excel Workbook, as in the figure below.
The behavior may appear to be inconsistent between existing files however, it occurs in any new file you attempt to create in Excel.
In Microsoft Excel, when attempting to use controls on the PowerPivot ribbon, you find that the controls are grayed out, as in the following figure.
0 kommentar(er)
