Results 1 to 3 of 3

Thread: What is the best options for a computer to have Excel function at its best?

  1. #1
    Seeker mickimouse75's Avatar
    Join Date
    Dec 2014
    Location
    Victoria, BC
    Posts
    5
    Articles
    0

    What is the best options for a computer to have Excel function at its best?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good afternoon,

    I'm currently running Excel 2010 on a Dell Vostro 460, Intel Core i5-2500 CPU @ 3.3GHz, 8GB RAM, 64-bit OS.
    My sheets that I typically work with are from 700KB to 10000KB, and I usually have several open at the same time. I have links going between several sheets also. The most complicated things I have in my sheets are vlookup and index/match formuals, as well as a few macros. Nothing earth-shattering.
    I continually run into issues with Excel being extremely slow, often with a (Not Responding) error, and my IT department cannot provide any answers.
    I'm under the belief that there has to be people out there that run much more complicated Excel stuff, and do it with great ease, and I'm wondering if the type of computer, etc might be a part of my issue.

    Would anyone be willing to share their computer types/details and any thoughts/ideas of what might be the best way to decrease the slowness I experience?

    Very appreciatively,
    Mike

  2. #2
    In my experience, slow workbooks are usually down to too many formulas, poorly designed spreadsheets, and/or events firing too frequently.

    And to make it worse, Excel seems to be getting slower in itself, MS keep sending out updates that create further problems, and the laptop invariably gets choked up with too much other stuff.

    I have no idea what a Dell Vostro 460 is like, but your CPU, RAM would suggest you should be OK. How old is it? Have you had it checked over by a specialist firm (I know your IT department should be able to do that, but maybe that is asking too much)?

  3. #3
    Seeker mickimouse75's Avatar
    Join Date
    Dec 2014
    Location
    Victoria, BC
    Posts
    5
    Articles
    0
    Thanks Bob!

    I appreciate your input. I suspect that I'll have to start learning databases at this point as I do have a large amount of formulas to bring all the information I need into one spot.
    My computer is nearly 3yrs old, and with brief inspection, seems to be ok, but I wanted to ask my question on here before have IT do extensive checks on the computer.
    History has been that I just get a new computer about every 3yrs, but was hoping there was another solution.
    Thanks again!

    Mike

Posting Permissions

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