I frequently need to run operations in big Excel tables (e.g. 100000 rows x 1000 columns - file size >100 MB) and likely due to the file size, when I try to do one calculation across the whole table, it takes longer than "expected" (?) or freezes up. (on the side, I need to have my MS outlook open, some MS WORD files and an internet browser with multiple tabs).
Q1. any suggestion how to operate Excel (i.e. work on a large spreadsheet) faster
Q2. does freeing up RAM help run a faster Excel
Q3. any suggestion how to operate a big Excel table fast or without crashing Excel ?