Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hardware for optimum Excel performance
Hi, I have several very large excel files (30MB+) which I need to update and recalculate regularly. I currently do this on my 1.7GHz/256MB RAM/ 20GB HD laptop. However, it takes a long time, and is susceptible to crashing. I want to buy a desktop machine specifically for optimised Excel performance. What should I look out for - is RAM more important than processing speed? I'd sooner not spend a huge amount of money. A related question - I currently use Excel 2000. While I'm in the process of upgrading, are later versions of Excel quicker? Any suggestions most welcome. Bertie. -- claytorm ------------------------------------------------------------------------ claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610 View this thread: http://www.excelforum.com/showthread...hreadid=397716 |
#2
|
|||
|
|||
Quite honestly, I would rather see you optimize your workbooks instead of
your machine. If the amount of data is making the files 30+MB, then I would be looking at getting my data into a proper database. Otherwise, perhaps your files just need to be cleaned of residual "dirtyness". See: http://www.officearticles.com/excel/...soft_excel.htm http://www.officearticles.com/excel/...ft_excel .htm The second article is provided because, often, moving worksheets to a new workbook can reduce file bloating. Also, to my knowledge--no, higher versions of Excel don't mean they're more efficient, but that's just experience of use. I could be wrong. If I had to suggest anything regarding hardware, I'd say upgrade to 512MB RAM, but I wouldn't go buy a new machine 'cause I don't think you'll be rewarded. Make sure your machine is running as efficiently as possible by keeping it clean: http://www.officearticles.com/misc/h...hard_drive.htm Good luck! ************ Anne Troy www.OfficeArticles.com "claytorm" wrote in message ... Hi, I have several very large excel files (30MB+) which I need to update and recalculate regularly. I currently do this on my 1.7GHz/256MB RAM/ 20GB HD laptop. However, it takes a long time, and is susceptible to crashing. I want to buy a desktop machine specifically for optimised Excel performance. What should I look out for - is RAM more important than processing speed? I'd sooner not spend a huge amount of money. A related question - I currently use Excel 2000. While I'm in the process of upgrading, are later versions of Excel quicker? Any suggestions most welcome. Bertie. -- claytorm ------------------------------------------------------------------------ claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610 View this thread: http://www.excelforum.com/showthread...hreadid=397716 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |