Please Recommend a PC Configuration for Heavy Excel Calculations - Microsoft Office Excel

london735 · 10.07.2009, 13:58

Hello!
I have recently ran into a productivity wall with my Pentium M 1,7 GHz Sony laptop, that I bought 3 years ago. I am working on a model of one process in Excel and the current version of the file is 200 Mbs comprised of 10 sheets filled to the brim with interrelated formulas (the final version is going to be close to 500 Mbs). Understandably my laptop is refusing to show any speed at all and takes minutes – and sometimes tens of minutes – to recalculate the workbook. I wonder if someone here is a power user of the Excel and can recommend to me a work station that can handle such files with ease? I am working in Excel 2003.
Here are the specs of one PC that the local computer firm is offering to me:

Desktop:
Intel Core 2 Duo E7400 / MB Intel DG41RQ / DDRII 2048Mb PC6400 Kingston / HDD 250Gb Seagate 7200 rpm SATA / Card Reader (CF, MMC, SD, MS) / Video on board / DVD.RW Pioneer / Sound / АТX YY 400w

Laptop:
Toshiba Qosmio F50-127 Intel CoreDuo P8600 2.4
15.4"/G97/4G/320/DVDRW/WF/BT/Cam/VHP

Please let me know what you think!)

Thanks!

EducatedFool · 10.07.2009, 15:46

First off, try to redesign your workbook instead of improving the hardware productivity:

Replace formulas (especially interrelated formulas) with macros
Clear cells formatting
etc

What is the size of laptop's RAM modules?

london735 · 10.07.2009, 16:05

My current laptop ha only 500 MB of ram...BTW is the cell formatting very resource-demanding?

10.07.2009, 13:58	#1
london735 Пользователь Регистрация: 20.06.2008 Сообщений: 45	Please Recommend a PC Configuration for Heavy Excel Calculations Hello! I have recently ran into a productivity wall with my Pentium M 1,7 GHz Sony laptop, that I bought 3 years ago. I am working on a model of one process in Excel and the current version of the file is 200 Mbs comprised of 10 sheets filled to the brim with interrelated formulas (the final version is going to be close to 500 Mbs). Understandably my laptop is refusing to show any speed at all and takes minutes – and sometimes tens of minutes – to recalculate the workbook. I wonder if someone here is a power user of the Excel and can recommend to me a work station that can handle such files with ease? I am working in Excel 2003. Here are the specs of one PC that the local computer firm is offering to me: Desktop: Intel Core 2 Duo E7400 / MB Intel DG41RQ / DDRII 2048Mb PC6400 Kingston / HDD 250Gb Seagate 7200 rpm SATA / Card Reader (CF, MMC, SD, MS) / Video on board / DVD.RW Pioneer / Sound / АТX YY 400w Laptop: Toshiba Qosmio F50-127 Intel CoreDuo P8600 2.4 15.4"/G97/4G/320/DVDRW/WF/BT/Cam/VHP Please let me know what you think!) Thanks!

10.07.2009, 15:46	#2
EducatedFool Программист VBA СуперМодератор Регистрация: 13.07.2008 Сообщений: 6,858	First off, try to redesign your workbook instead of improving the hardware productivity: Replace formulas (especially interrelated formulas) with macros Clear cells formatting etc What is the size of laptop's RAM modules? __Полезные надстройки для Excel. Парсинг сайтов и файлов. Макросы любой сложности на заказ. Мониторинг цен конкурентов

Похожие темы
Тема	Автор	Раздел	Ответов	Последнее сообщение
Как запретить запуск программы на VBA Excel 2003 в Excel 2007	kovalevskivf	Microsoft Office Excel	2	15.05.2009 16:47
Экспорт из Access в Excel, Экспорт из отчётов в таблицу Excel	Kissedbythegod	Microsoft Office Access	1	31.05.2008 22:15
очень громоздкие финансовые модели в Excel, а Excel не тянет	Ragazza	Microsoft Office Excel	7	03.10.2007 20:08
Формирование из excel в ASCII, у меня он формирует по одному клиенту а в Excel нескол	Askat	Общие вопросы Delphi	0	18.07.2007 06:28
Как вытащить данные из Excel в бд dephi, а потом (после работы с данными) сформировать новый файл excel.	Геля	БД в Delphi	1	10.04.2007 15:11

10.07.2009, 16:05	#3
london735 Пользователь Регистрация: 20.06.2008 Сообщений: 45	My current laptop ha only 500 MB of ram...BTW is the cell formatting very resource-demanding?