Forum Discussion

JackTradeOne's avatar
JackTradeOne
Tin Contributor
Nov 14, 2026

Support for lists-in-a-cell and functions such as FLATTEN disappeared

A strange thing happened to me with Excel. I am signed up for Current Channel (Preview), with Microsoft® Excel® for Microsoft 365 MSO (Version 2611 Build 16.0.20625.20076) 64-bit. When Microsoft released the new list-in-a-cell update and the new HASANY, FLATTEN, etc. functions, they were made available in my installation and I used them in a couple of workbooks. But a week or so later, there was an update to Excel (or the whole Office 365 suite) and those functions just disappeared.

 

If I try to open a workbook which uses these features, I get the message  "This workbook is set to Compatibility Version 3, which is not supported by this version of Excel." It offers to "Downgrade" the workbook, but that only results in a workbook full of error messages. 

It happened to me before that a roll up of a new function was delayed for a while, but I've never experienced a roll back. Was it just me or part of a plan? I asked CoPilot, but it has no idea, strangely enough.

4 Replies

  • Thanks to those who responded. I obviously didn't overwrite existing files, and my organization didn't change any policies during this period. I'm not sure when exactly the new features disappeared; I just realized it a few days ago since I didn't open these files for a while. I guess I'll just have to live without them until they are generally available.

  • SelinaKnow's avatar
    SelinaKnow
    Iron Contributor

    Keep an untouched copy of the workbook and switch the Office Insider channel to Beta if your organization allows it, then run Update Now. Once Excel opens the file with Compatibility Version 3 again, save a separate copy rather than overwriting the original. That gives you a clean rollback point if the feature changes again.

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    These are the minimum builds required (Current channel is below this):

    • Windows: Version 2610 (Build 20520.20000) or later
    • Mac: Version 16.114 (Build 26092111) or later

    If the computer is on the proper Beta channel, the functionality should be there. There are no more Beta roll outs. The channel has been complete for a month.

    Put multiple values in one cell with lists and arrays in Excel | Microsoft Community Hub

     

    If you're experiencing a rollback, this suggests your organization Intune policy is not exempting you from regular updates to use Beta.  If you're not excluded for the usual push, the roll back can happen. Only a guess, if you're on an enterprise computer, it's not mentioned in your post.

  • Your workbooks were created with lists and Compatibility Version 3, but your Current Channel (Preview) installation no longer recognizes that version. Microsoft’s announcement describes these features as a preview initially rolling out to the Beta Channel; preview features can be paused, adjusted, or removed. That does not establish why your installation changed, or prove that this was a planned rollback. Preserve an untouched copy of each workbook and avoid saving the downgraded version over the original. Check File > Account for the actual update channel and build, then use Update Options > Update Now and restart Excel. If you have access to a separate Beta Channel installation with the feature, test a copy there; availability can still vary during rollout. Send feedback from Excel with the channel, build, exact message, and when the feature disappeared. Microsoft does not promise that downgrading will preserve these formulas.