Something strange happened this week when I was giving a PowerPivot training.
The PowerPivot Field list disappeared and the PivotTable Field List came back. This happened after a few minutes after I had made a PowerPivot table in a new document. It seemed to happen just in a moment, not after any particular action. Saving, closing and reopening the document solved the problem.
This triggered me to look at the autosave options. When you create a new document and autosave is on, make sure it saves it with the right extension. In this case, the format of autosave was on OpenDocument Spreadsheet (.ods). This caused the PowerPivot Field list to disappear and only the PivotTable field list was available.
This can be undone when the document type of autosave is on Excel Workbook.
The autosave options can be changed under File > Options > Save.
Blogging about Microsoft Fabric, Power BI, Power Platform and other things I find interesting.
Friday, October 5, 2012
Subscribe to:
Posts (Atom)
Featured Post
Microsoft Ignite 2024 - My Key Highlights
Last week was the annual Microsoft Ignite conference in Chicago. In this blog, I will take you through my most important highlights of the ...
-
Just before the holidays start, I'd like to share this little trick I came across in Power Query. I recently had the need to remove zero...
-
After Installing the PowerShell Power BI Management cmdlets a few months back, I finally managed to get a dataset refresh working, initiat...
-
Problem Recently I was working on a new project and was trying to deploy my SSIS project with several packages to the catalog for the first ...