Results 1 to 11 of 11
  1. #1
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    File Opening (Excel 2000 / SP3)

    I open a lot of Excel files by double clicking the filename in Windows Explorer. Using the same file and two machines very similar in specs one machine takes about 4 times longer to open the same file than the other machine does. The slower opening computer is connected to a Linksys Router and is on line when it is turned on because it is connected to a cable modem while the other computer is a stand-alone machine with no Internet connection. Also the slower machine has a lot more programs installed on it but the programs which load in systray on both machines are kept to a minimum. The slower machine is XPP and the faster machine is XP Home. Is there anything that can be done to speed up the opening of these files on the slower opening machine? I should mention that there are no addins being loaded at startup on either machine.
    H Lewton

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening (Excel 2000 / SP3)

    The first thing I would check is if an Anti-Virus program on the slow machine is slowing the open down.
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening (Excel 2000 / SP3)

    See if cleaning out the WINDOWS/TEMP folder helps.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: File Opening (Excel 2000 / SP3)

    Legare Coleman,

    Thought of that but they both run the latest version (2003) of Norton's Antivirus program. I forgot to say that in my original note.

    Thanks.
    H Lewton

  5. #5
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: File Opening (Excel 2000 / SP3)

    Peiterse,

    Thanks but I do that on a very regular basis and it doesn't seem to make a noticeable difference.
    H Lewton

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,830
    Thanks
    136
    Thanked 483 Times in 460 Posts

    Re: File Opening (Excel 2000 / SP3)

    I encountered a similar problem some time ago.
    2 identical machines on a network loading the same file from the same server location took incredibly different times to load.
    Drove me crazy. Reinstalled Excel several times etc.
    It turned out that there was a discrepancy in the clock setting of the 'slow loading' PC.
    When this was adjusted, the file loading performance was identical.
    Weird.

    zeddy

  7. #7
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: File Opening (Excel 2000 / SP3)

    zeedy,

    My clock is automatically adjusted and maintains the exact time so I don't know how I could make any change to that.

    Thanks.
    H Lewton

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening (Excel 2000 / SP3)

    I *think* Zeddy meant the processor clock frequency.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: File Opening (Excel 2000 / SP3)

    pieterse,

    Sorry about that. What is there to adjust with the processor clock frequency and how is it done?

    Thanks.
    H Lewton

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Opening (Excel 2000 / SP3)

    Hmm, no idea, actually. Would be some sort of BIOS setting I guess.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,830
    Thanks
    136
    Thanked 483 Times in 460 Posts

    Re: File Opening (Excel 2000 / SP3)

    Try a Google search on "overclocking"

    Doesn't sound like this is your problem though.

    zeddy

Posting Permissions

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