Excel 2010 x64 crashing with ram usage above 50% :(

[oynaz]

Or in that time an improved version of excel will come out and I'll have no more issues like this.

You're an optimist, I'l grant you that much ;-)

 

[Nothinman]

Once again you are right, it's many times faster for me to analyze and manipulate data when it's visual the way it is in excel. I'm not a professional, it's a hobby I do in my spare time and excel is something I know a little so switching to other software would be difficult right now. In all reality I could do this using much less resources even by putting my data into .txt files and doing the calculations with a simple programming language but it would take much longer and would be even more prone to errors.

Anyways, once I get to my next step with this project I think I will consider other software so I appreciate recommendations. Or in that time an improved version of excel will come out and I'll have no more issues like this. It's amazing how much I can do in excel these days regardless, in the past I had to do certain things in Basic (programming language for kids, but it does the job and is easy )

I wouldn't expect a better version of Excel any time soon, it took MS essentially forever to allow >65K rows and 2013 is already in preview and I would bet it's just a metro face lift.

 

[xSauronx]

I wouldn't expect a better version of Excel any time soon, it took MS essentially forever to allow >65K rows and 2013 is already in preview and I would bet it's just a metro face lift.

just a preview, but it has some ok new features, too.

http://arstechnica.com/information-technology/2012/07/first-look-excel-2013/

http://www.techradar.com/reviews/pc...software/office-2013-1089108/review?artc_pg=3

not enough changes to make me excited as a casual user, but some neat features ill find handy whenever i get around to using it one day

 

[imported_Jid]

All I want for christmas is a spreadsheet program that doesn't wig out when you use a lot of resources. Are any of the alternatives to Excel any better?

 

[lxskllr]

All I want for christmas is a spreadsheet program that doesn't wig out when you use a lot of resources. Are any of the alternatives to Excel any better?

You could try LibreOffice. I suspect it won't be better, but it's free to try.

 

[Nothinman]

just a preview, but it has some ok new features, too.

http://arstechnica.com/information-technology/2012/07/first-look-excel-2013/

http://www.techradar.com/reviews/pc...software/office-2013-1089108/review?artc_pg=3

not enough changes to make me excited as a casual user, but some neat features ill find handy whenever i get around to using it one day

And the entire UI has that ugly as shit, flat look and screaming at me. No thanks.

 

[Zxian]

Is your particular file something that you could share? I've heard of issues when people use large amounts of memory, but I'm wondering if it has something to do with the types of calculations done as opposed to the sheer memory usage. I've got a workbook here that uses ~5GB of RAM alone and I haven't had any issues with instability yet. Volatile and array functions are something that I tend to avoid in all my work, so I'm guessing it may have something to do with that.

 

[KentState]

Just a suggestion, but try the PowerPivot plugin if you have that available. We have a lot of problems with Excel, even 64bit edition for our spreadsheet users, but PowerPivot seems to be an alternate solutions that works.