Dynamic Arrays on Excel 2021

Copper Contributor


I have the Microsoft Office LTSC Professional Plus 2021, Version 2108(Build 14332.20546 click to run) installed on my Windows PC. However, the dynamic array functions such as Sort, Sortby, Filter, etc., are not available for me to use. 

I found out that if I open Excel in safe mode, they suddenly become available. 

How can I fix this?

2 Replies
What is the default File format you have set up in File, Options, Save tab?

Excel Workbook

@Jan Karel Pieterse