Forum Discussion
Excel ran out of resources while attempting to calculate one or more formulas.
The style reduction tool (third-party) tells that this file has no less than 53016 slow calculations, which are for the most part whole-column references in formulas.
Excel seems to pre-allocate memory for those columns when calculating formulas, and since you are doing it with a XLSX file, it's 1 million rows that are pre-allocated for each of those whole-column references.
Converting this XLSX file back to a XLS file fixes the problem you are having, because then each column is made of 65536 rows, which means a lot less. Excel still pre-allocates a lot of unused rows but at least several orders of magnitude less.
Also, for the record, you can also remove those whole-column references to help Excel as well. For instance if the sheet being referred to with a column-wide reference such as E:E has say 500 actual rows of data, you could replace E:E in formulas with E1:E500. Or perhaps E1:E1000 if you'd like to let the data grow without having to update the formulas for some time.
Hope it helps.