I have been using Excel off and on for 25+ years and I have encountered the same
problem each time. It takes too long to calculate my huge spreadsheets. Often up to 30 minutes
and sometimes it stops or I stop it in frustration. In addition I need to do several runs an hour.
I've concluded the software is not suitable for such large spreadsheets described below.
Records often in excess of 100,000 (rows) several columns of formulae.
Can anyone offer an alternative to Excel ? I possess a Lic Stata V10 software and wondered if
this could be suitable.
I'm using a Dell 7500 Workstation with 24GB hard drive and 320GB free space on my hard drive.
Any help with software advice much appreciated