K
Knut S
I'm working with large Excel spreadsheets and running into problem with the size of it. Currently it is around 45 MB and getting unstable. Is there anything I can do to reduce the memory requirements in Excel ?
I'm having around 3000 rows and 300 columns of data split on a few input sheets. Then, there are lots of analysing sheets with calculations like divisions, multiplications and lookupfunctions and if-statements and plots.
Should I avoid formatting, does the data organising impact the memory (formulas link between sheets etc.), is multiplication less demaning than division, what about Array formulas ...or.....
I'm having around 3000 rows and 300 columns of data split on a few input sheets. Then, there are lots of analysing sheets with calculations like divisions, multiplications and lookupfunctions and if-statements and plots.
Should I avoid formatting, does the data organising impact the memory (formulas link between sheets etc.), is multiplication less demaning than division, what about Array formulas ...or.....