Hello folks - been trying to use an Excel file with a pivot table created on a Windows machine - the pivot table doesn't work - can't edit, refresh, use filters (slice/dice) or anything. After looking online I joined the Office Insider program and tried to pull down the 16.6 version of Excel as suggested - however all I got thus far is version 16.25 - Doesn't look like there even IS a version 16.6 according to MSFT release notes for Excel. (But there is a video on YT showing how to pull down that version which supposedly does work with Pivot tables...)
This is Office 365 subscription as installed from IBM app store (and updated via Office Insider) on a MacBook PRO.
Has anyone encountered this and have a solution for it?