Home

Problems using Pivot tables in Excel 16.25 on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-393022%22%20slang%3D%22en-US%22%3EProblems%20using%20Pivot%20tables%20in%20Excel%2016.25%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393022%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20folks%20-%20been%20trying%20to%20use%20an%20Excel%20file%20with%20a%20pivot%20table%20created%20on%20a%20Windows%20machine%20-%20the%20pivot%20table%20doesn't%20work%20-%20can't%20edit%2C%20refresh%2C%20use%20filters%20(slice%2Fdice)%20or%20anything.%20After%20looking%20online%20I%20joined%20the%20Office%20Insider%20program%20and%20tried%20to%20pull%20down%20the%2016.6%20version%20of%20Excel%20as%20suggested%20-%20however%20all%20I%20got%20thus%20far%20is%20version%2016.25%20-%20Doesn't%20look%20like%20there%20even%20IS%20a%20version%2016.6%20according%20to%20MSFT%20release%20notes%20for%20Excel.%20(But%20there%20is%20a%20video%20on%20YT%20showing%20how%20to%20pull%20down%20that%20version%20which%20supposedly%20does%20work%20with%20Pivot%20tables...)%3C%2FP%3E%3CP%3EThis%20is%20Office%20365%20subscription%20as%20installed%20from%20IBM%20app%20store%20(and%20updated%20via%20Office%20Insider)%20on%20a%20MacBook%20PRO.%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20encountered%20this%20and%20have%20a%20solution%20for%20it%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-393022%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivot%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
jeromepineau
Occasional Visitor

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? 

Thanks!

Related Conversations
Solving Name conflict in excel
stanoh in Excel on
0 Replies
Macro to Import Information from Email Attachments into excel
calof1 in Excel on
0 Replies
i am stuck on vba and copying row based on value
tduff1460 in Excel on
1 Replies
Room Booking using Excel
Maddie1215 in Excel on
0 Replies
How to get to the last line with data in an Excel workbook?
seanp413 in Excel on
2 Replies
Excel Formula Question
BigErn1175 in Excel on
3 Replies