Forum Discussion

sparkl's avatar
sparkl
Frequent Visitor
3 years ago

Availability of Table.StopFolding

Hey all, learend that there is this new Power Query function "Table.StopFolding", but I can't see that happen in power query editor in my Excel version (365 Enterprise, Excel version 2108, build 1432...
Need Help
Tips and Tricks
BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi sparkl , 

I believe this was added to Excel around May 2022. I can access it from Excel Power Query on this version:

Microsoft® Excel® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20002) 64-bit

You'll need to ask your Enterprise Admin to update the Office apps to get the latest version if you don't currently have it.

 

If you can't get an update, then you can use Table.Buffer in the same way, but just be mindful that this will load your entire table into memory, so may not get you the overall performance gains you're after.

 

Pete

  • sparkl's avatar
    sparkl
    Frequent Visitor
    3 years ago

    So many thanks. That's very helpful. Let me wait our enterprise update in that case.

    And yes, it's table.buffer lead me to awareness of this stopfolding, table.buffer is useful in some ways.

    Good day, Pete

    🙏