How to Reduce Memory requirement of large Excel workbooks ?

G

Guest

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.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to reduce file size of excel workbooks 1
Linking worksheets in Excel 1
Excel 2007 out of memory 1
How to reduce Excel file size from 17.2 MB 3
Speeding up Excel - Large amounts of data, no complex formulas 3
How do you move names and data between large Excel 2003 workbooks? 1
How to separate Excel Workbooks into new files 0
How to separate Excel Workbooks into new files 0

Top