+ Reply to Thread
Results 1 to 6 of 6

Advice to select the Desktop configuration PC

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    196

    Advice to select the Desktop configuration PC

    Dear Friends.

    Currently I am using desktop having configuration of Intel(R) Core(TM) i3-4150 CPU @ 3.50GHz, 8GB RAM, 64 bit operating system, MS office 2010.

    Mostly I work on multiple excel files of approx. 150mb size each. ( rows of 9 lac with 5 pivot table).
    My excel hangs and it restarts automatically after popping errors.
    Its really troublesome to work and affecting my productivity.

    We plan to buy i5, 8/16 GB RAM, 1 TB HDD.
    Will this configuration solve my problems to excel ?

    Also advice the latest configuration PC which can solve my excel problem.

    Please assist.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    1,549

    Re: Advice to select the Desktop configuration PC

    Others will be more knowledgeable, but what version of office will you be running in the future as this will also influence things

    The structure of the spreadsheets may also be part of the reason for hanging, but they are large sheets. Popping errors is not a very specific description of a problem. is it when running vba code, running out of memory, refreshing a link etc?

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,103

    Re: Advice to select the Desktop configuration PC

    An SSD will probably open your workbooks faster and suing 64-bit Excel, otherwise your RAM usage will cap out very quickly

  4. #4
    Registered User
    Join Date
    04-01-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Advice to select the Desktop configuration PC

    A ryzen cpu offers more bang for bucks, especially since intel decides to delay icelake yet again.
    I'd recommend ryzen 5 /7,

    If you're not into serious gaming or OC'ing, no need for the newer x570, x370/x470 will do.
    I'd also recommend nvme m2, the price difference with ssd is negligible these days.
    Last edited by denywinarto; 08-07-2019 at 08:02 AM.

  5. #5
    Registered User
    Join Date
    11-11-2019
    Location
    London
    MS-Off Ver
    microsoft pc
    Posts
    6

    Re: Advice to select the Desktop configuration PC

    An SSD will probably open your workbooks faster and suing 64-bit Excel

  6. #6
    Forum Contributor
    Join Date
    12-12-2017
    Location
    Franklin , New Zealand
    MS-Off Ver
    2007
    Posts
    187

    Re: Advice to select the Desktop configuration PC

    Hi all , great thread , i too am looking at an upgrade .
    Were told that you can have all the power you want but my 2007 excel version is limited to 2gb speed excel processing anyway .

    Im looking at newest excel to buy and the talk is to get high core count , high clock speed , multi thread . HUH?? .

    I5 , 7 or 9 . Im confussed also would love some advise to run my about to go over 500,000 row sheet with a couple of complex macros .
    Thanks .
    I am grateful for all answers to my questions .
    Also i give a reputation even if not answered .

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1