Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default What it takes for Excel to run faster ?

Hello there,

Just wondering what hardware is more important for excel to run faster ?
should I put the money on a faster CPU or just get more RAM for my PC, or
even a faster harddrive ? I need to handle loads of reports everyday and a
lot of matchings (vlookups) / large scale formattings - no extreme
calculations or chartings needed.

my current pc is a crappy pentium 4, 1.xx GHz with 1GB ram as I know.

Many thanks in advance.

Steven Vegeta
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default What it takes for Excel to run faster ?

Hi Steven,

It depends on the type of application, but in general fast CPU, fast memory and lots of it and fast busses are important.
Take into consideration that all this may change quite a bit with the arrival of the next Excel release, which will benefit from
multicore or multiple processors, use of calculation servers etc.
For now, lots of tips can be found he

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steven Vegeta" <Steven wrote in message
...
| Hello there,
|
| Just wondering what hardware is more important for excel to run faster ?
| should I put the money on a faster CPU or just get more RAM for my PC, or
| even a faster harddrive ? I need to handle loads of reports everyday and a
| lot of matchings (vlookups) / large scale formattings - no extreme
| calculations or chartings needed.
|
| my current pc is a crappy pentium 4, 1.xx GHz with 1GB ram as I know.
|
| Many thanks in advance.
|
| Steven Vegeta


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default What it takes for Excel to run faster ?

If it intensive calculations, I would say more memory. If you are frequently
opening and saving/closing workbooks, maybe a faster HDD. Invariably the
best thing you could do is to optimise the formulae. Take a look at
www.decisionmodels.com

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Steven Vegeta" <Steven wrote in message
...
Hello there,

Just wondering what hardware is more important for excel to run faster ?
should I put the money on a faster CPU or just get more RAM for my PC, or
even a faster harddrive ? I need to handle loads of reports everyday and a
lot of matchings (vlookups) / large scale formattings - no extreme
calculations or chartings needed.

my current pc is a crappy pentium 4, 1.xx GHz with 1GB ram as I know.

Many thanks in advance.

Steven Vegeta



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel file with hyperlinks takes a long time to open over the network Didier P Links and Linking in Excel 3 July 4th 06 04:39 PM
MS Query takes along time to open TonyL Excel Worksheet Functions 0 April 6th 06 01:44 PM
Saving Excel files takes a huge amount of time Heavy Excel user Excel Discussion (Misc queries) 6 January 12th 06 12:11 PM
Excel takes along time to calculate TonyL Excel Worksheet Functions 0 May 31st 05 12:19 AM
Edit query takes a long time TonyL Excel Worksheet Functions 0 May 11th 05 10:50 PM


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"