I use a large spreadsheet with external links and formulas. I calculate manually (F9). When I open the spreadsheet it works well. The longer I have it open the slower it becomes until I have to close it and reopen, at which point it works well again for awhile. How can I speed up my calculations? is there a cache I can dump or something?
Solved by T. Y. in 19 mins