You can take the file to a computer with higher configuration and open it, and then solve it in the following ways:

1, split. If the workbook contains multiple worksheets, you can split the worksheets into different workbooks.

2, slimming, delete some duplicate fields, worksheets, etc.

3. Sorting: Divide a large worksheet into one or more small worksheets, and optimize or delete formulas that occupy a lot of memory, especially array formulas.