Hello All,
I have created a spreadsheet that searches through a large excel database. The spreadsheet consists of 8 sheets with about 4,500,000 cells of formula's per sheet. I have a Dual Core 2gb laptop and i cannot search through my database. I have read that Excel 2007 has a maximum amount of virtual memory it can use (around 2gb's or less.)
I would like to know if anyone has ideas for solutions so that I can use my spreadsheet instead of only being able to use it with limited data. I am wondering if their is software to speed it up, a better computer to run the calculations (over 36,000,000 when inputs are changed) better. I am open to any and all suggestions.
Franky
Bookmarks