If the table of 10.5M really needs high hardware configuration, you can take the file to a computer with high configuration and open it, and then solve it by the following methods:

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.