Is this dataset too big for Excel to handle?
I’ve got about 60000 points. Getting it all in Excel is no problem, but when I start doing more complex functions, like subtotal, it’s running MEGA slow. This is on a Macbook Pro with 4GB RAM. When I tried to chart about 5000 points – x y scatter style – so that I could run some stats, fit a line, find errors, etc, it froze up for real. Am I just pushing up against limits of excel or is there something else wrong?
This question is in the General Section. Responses must be helpful and on-topic.