Previously I had a excel file of 500+ MB(has lot of formulas) and was creating memory problem, some suggested to remove formatting from it.
Recently faced the same problem again and so removed >90% of formatting(borders, font style other than that of worksheet, fill color, Italics, bold)
Kept only which are ver much needed.
And then saved it .
Previously it was of 527 MB , now it is of 533 MB .
Also Memory usage previously was ~60%, now it it >70%
Can you please suggest something