Why my Microsoft 365 EXCEL mobile version doesn't have pivot table option shown on my Data ribbon ?

Question

As shown, I just subscribed to a 1-year Microsoft 365 Personal Plan, and I downloaded the Microsoft 365 series on my laptop; however, when I tried to insert the pivot table in my EXCEL sheets, I couldn't find the pivot table options in the "Insert ribbon", and also found out that I downloaded the mobile version on my laptop, but there's seems no any other version options for me to choose to download ? Is it because of the mobile version on my laptop, so "the pivot table options" disappeared ?

Does anyone know where I can download the Microsoft 365 series app for the "laptop" Windows system?

(I don't know why I can't insert the picture in this question.....)

Answer 1

You'll find it on the 'Insert' ribbon.

Answer 2

No, it didn't show on my insert ribbon ......

Answer 3

For consumers (as opposed to business users) there are three versions of Microsoft 365 for the PC.

When you purchase a subscription to Microsoft 365, you can download the Microsoft 365 apps to your PC. The downloaded Excel app most certainly has the pivot table function.

With your subscription to Microsoft 365, you are also entitled to use the online version of the Microsoft 365 apps. This is the version of Microsoft 365 that you will be using when you are working with files directly on your OneDrive. The online version of Microsoft 365 doesn't have all the features of the downloaded version - yet - but it certainly does include the pivot table function.

Someone who has not paid for a subscription to Microsoft 365 can still use the free online version of the Microsoft 365 apps. Being free, these apps have limitations, and in the case of Excel, it does not have the pivot table function.

If you have paid for a Microsoft 365 subscription, the way to be sure that you are using the apps you paid for, whether the downloaded version or the online version, is to sign in with your Microsoft account.

Answer 4

Yes, but you are using the PC version. The version in question is the mobile app for Adnroids. Do you have any tips there?

Answer 5

Re:also found out that I downloaded the mobile version on my laptop,

There is no pivot table button at my Android Excel app too .