Hi all,
Anyone know what the realistic limits are excel for numbers of columns and rows?
Got someone at work complaining about slow performance on a pretty powerful PC (4th gen i7, 16GB of ram and 250GB SSD) when trying to make changes to an excel spreadsheet, further investigation shows its quite a few complex formulas, over 500,000 rows and 400 columns, they keep telling me "It should work, the limit is 64000 columns and 1 million rows", I'm no database expert but I am really thinking they should be using something a bit better suited to large databases.
So in summary, whats the practical limit on excel when you should really be considering a proper database solution?
Anyone know what the realistic limits are excel for numbers of columns and rows?
Got someone at work complaining about slow performance on a pretty powerful PC (4th gen i7, 16GB of ram and 250GB SSD) when trying to make changes to an excel spreadsheet, further investigation shows its quite a few complex formulas, over 500,000 rows and 400 columns, they keep telling me "It should work, the limit is 64000 columns and 1 million rows", I'm no database expert but I am really thinking they should be using something a bit better suited to large databases.
So in summary, whats the practical limit on excel when you should really be considering a proper database solution?