Pivot Table Design button not visible in Excel Onlie

Question

Excel Pivot Table.pdf

I am using M365 Excel online build 16.0.19602.42308

The Pivot Table options don't seem to be complete and don't operate properly. I don't see a Design option. Also, the "Field List" and "Settings" buttons don't operate properly. They highlight when clicked on but don't change anything on the screen. I was not able to access any "Settings". I am trying to drop the subtotals on the rows in my pivot table. For now, I will used the MacOS version of Excel that I can load on my macbook directly.

Answer 1

Hello,

This is likely intended design, the web version of excel does not have the same functions as desktop excel. The function is likely found in your macos version or the windows version.

Hope this helps,

JC

Answer 2

Unlike in the desktop program there is no separate Design tab for Pivot Tables in the Excel Online web app. All available features are on the one PivotTable tab. All of the web apps lack much of what the desktop versions include.