Looking for some help and clarification on Excel Pivot Tables that have Filters. I have my home budget and check registers in Excel and have a pivot table with 2 filters, one for month, and one for year. When I add data on my MacBook Pro and refresh the the pivot table, it works just fine. When I do the same thing on my iPad, it crashes and closes the file.
My Mac is running OS Ventura 13.5.1 and my iPad is 16.6. I am including a small Excel file that has the same layout, headers, and drop downs. The data is fictitious.
In closing, I am quite sure this used to work fine on iOS. I have even contacted Microsoft via chat 2 times about this, and all they can say I must either have a damaged file, or hardware issues.
I have recreated files multiple times, and still am having the same issue.
Hello,
Same happens to me in Excel on iPad.