+ Reply to Thread
Results 1 to 7 of 7

Laptop recommendation to run Excel

  1. #1
    Registered User
    Join Date
    09-27-2007
    Posts
    61

    Laptop recommendation to run Excel

    I searched and found none. Hopefully, correct thread...

    Any recommendations for a laptop that can run well with spreadsheets?

    I have several files in Excel 2007 that take about 10 seconds to open in my HP nc6320 (compaq): Intel Core 2 CPU T5600 @1.83 GHz.

    < $2,000

    > $2,000

    Thank you for your assistance.
    -E

  2. #2
    Registered User
    Join Date
    08-21-2007
    Posts
    90
    How much RAM do you have? I run Excel 2003, with some very large XLS with lots of macros and run some 50,000 record Access mdbs with no problems or noticeable delay.

    I did not have any slowness with 1GB RAM, but I found going to 2GB RAM really speeded it up for me, because I only have a 2.0GHZ (single core) IBM
    T-30 with 7200rpm IDE HDD.

  3. #3
    Registered User
    Join Date
    09-27-2007
    Posts
    61
    I have 1 GB of Ram - it's a new laptop. It must be an HP performance issue. I'll need to read up on this, but I'd like to get better performance than what I have now.

    -EG

  4. #4
    Forum Contributor harrywaldron's Avatar
    Join Date
    05-24-2007
    Location
    Roanoke, VA
    MS-Off Ver
    Office Professional 2010 BETA
    Posts
    169

    Lightbulb

    I also agree that more RAM is always helpful. I'm actually using Excel 2003 on older Dell systems at work with 512MB of RAM and experience no delays, so it may not be the machine

    Below are a few more ideas:

    * Ensure your system has only the essential start-up services running (an IT person may need to help there), as these can slow your system down dramatically.

    * Anti-virus software will inspect macros for issues as spreadsheets are open (as a test, you or the IT person could temporarily disable this to see if it makes a difference)

    * Sometimes formulas, macros, and other attributes get embedded in the spreadsheet beyond the range of data. For example, if you had 1,000 rows of data, there may be hidden things in rows 1001 all the way through 65,536. If you had 1000 rows and go to row 1001, highlight it and then press ALT+SHIFT+Down-Arrow ... It will highlight all rows and you can DELETE these entire rows to make the worksheet smaller and possibly more efficient. Be sure you have a good backup of the original 1st.

  5. #5
    Registered User
    Join Date
    09-27-2007
    Posts
    61
    Thank you for the recommendations.

    In Excel 2007, I do press SHIFT + ALT + DOWN ARROW and nothing happens...

    I'm bumping up to a new HP laptop with 2GB of RAM. Hopefully, this will improve performance.

    Thank you.

  6. #6
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517
    For the average user, the issue with modern computers is not how fast they do the things they do quickly, but how slow they are to do the things they do slowly!

    This usually boils down to hard-disk performance, a slow hard disc can realy affect the responsiveness of an otherwise blisteringly fast machine.
    The advantage of a large RAM is that the PC does not have to keep going back the the disk, once it has loaded something it can keep it in RAM in case it needs it again. If you run out of RAM the least used block of data will be written back to the disk to free up the required space.

    Most disks are amazingly fast (compared to when I was a lad), but problems occur as they start to fill up.
    Check for defragmentation, is your MFT (Master File Table) big enough? is your paging file big enough?

    Another thing to consider is that laptops often put the hard disks into sleep mode if they are not being used (to save the battery), check on your power saving settings.

    Mark.

  7. #7
    Registered User
    Join Date
    09-27-2007
    Posts
    61
    Quote Originally Posted by johnnywinter
    How much RAM do you have? I run Excel 2003, with some very large XLS with lots of macros and run some 50,000 record Access mdbs with no problems or noticeable delay.

    I did not have any slowness with 1GB RAM, but I found going to 2GB RAM really speeded it up for me, because I only have a 2.0GHZ (single core) IBM
    T-30 with 7200rpm IDE HDD.

    Thanks Mark

    I think what you stated is key, as evidenced by Johnny Winter's 7200rpm IDE HDD
    Probably the Drive RPM contributes a great deal to the s/s performance. Mine is 5200rpm's.

    Thanks again.

+ 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