Excel Pivot Table Not Working in Excel for OS 14.6

I have been looking all over for an answer to this issue, but I never seem to find a clear answer. It seems that it must work based on what I have read, but I am missing something. Half my sales team is using Apple iOS products but love the pivot tables I have set up but we cannot get them to work in the iOS version of Excel from Office 365. Even versions that I know are fully updated.

I have an Office 365 Excel Workbook (Version 16.0.14). I have a data tab that has a table that is not linked to anything outside of the workbook. I have confirmed this by looking at the Existing Connections. Everything is in the workbook. I have created a simple pivot table off of that data looking at the sales of customers with one filter for months. I am doing this simple just to figure out what is going on. No matter what I do I get the message "This PivotTable connects to an external data source that's not supported in this version of Excel.". Although, I see people out there that claim it should work.

Any incite is appreciated. Thank you.

It was a regular pivot table and I had tried using a data model before and it didn't seem to work, but I realized that was an older version of Excel on our server. So this time I tried again but with the most current version through Office 365. It still did not work. In fact this time it had a message right away. "Read Only - You can't edit this file because it has content that this version of Excel cannot display". Then if I click on the filter to make a change I get the standard message in my original post.

I am attaching a sample of the workbook.