Results 1 to 12 of 12
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel time (2002)

    HI

    ONE OF THE FINACIAL GUYS AT WORK CREATED A SPREADSHEET WHICH IS 25MB, HE CAN OPEN IT WITHIN 1 MINUTE, HE HAS THE SAME COMPUTER SPECS (2.8 GHZ, 256 MB OF ram) AS HIS COLLEAGUE, BUT IT TAKES HIS COLLEAGUE ABOUT 5- 10 MIN TO OPEN THE FILE, THE FILE IS STORED ON A SHARED NETWORK DRIVE. ANTY IDEAS HOW TO SOLVE THSI PROBLEM.....

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

    Re: Excel time (2002)

    First, please turn off your CAPS Lock key. Typing in all CAPS is considered shouting, and is very difficult to read. Thanks.

    The usual causes for this are:

    1- The anti-virus program interfering with Excel opening the file.

    2- A slow or error prone network connection.

    3- Insufficient RAM memory that is resulting in a lot of paging to the page file.
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Jun 2005
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel time (2002)

    Well, i have checked the antivirus, i dont think it is the anti virus, as for memory, both users have same memory, i have increased their memoy paging file to 640

    (256*2.5 =640), still the same for one user, long time to open the spreadsheet. I disabled the antivirus and tried to open the file again no change .

    Thanks

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel time (2002)

    One other possibility - if the person with very slow access is not working on the same server as the person who created the file, he/she may be getting low priority over the WAN.

    And an expansion on Legare's advice - ask the person with very slow load times to close all other applications and see if it makes a difference.
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Excel time (2002)

    Thanks for turning off CAPS Lock. That is much easier to read.

    When you say you checked the anti-virus, did you just look at it, or did you turn it completely off and try to open the file. Looks can often be deceiving.

    Increasing the page file size probably would not help anything. The size of the page file does not affect how much the system pages, just how much virtual memory can be allocated. The problem might be in how the real RAM memory is being used (what is loaded into it).

    Have you checked the error rate and speed of the network connection?
    Legare Coleman

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel time (2002)

    Skips

    To test the network theory, copy the workbook to your colleagues local drive and then try opening it from there. I often get this problem with my accounts people...the pipe just ain't big enough and depends on the network traffic at the time.
    Jerry

  7. #7
    Star Lounger
    Join Date
    Jun 2005
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel time (2002)

    Well. I turnned the Anit Virus off, I copied the file into the local drive (C: drive ) still no change, and there are no other applications opened.

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel time (2002)

    How maddening...let me have a think and get back to you
    Jerry

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel time (2002)

    Is the Finance person using the Analysis Toolpak or any other Add-Ins that are not activated for the problem user? Is the file set for sharing? Does the Tools | Options | Calculation | Iterations settings differ between the two Excel installations?
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Excel time (2002)

    If you copied the file to his hard disk and have the same problem opening it there (assuming that there are no links in the workbook that need to be updated from network files), then the only two things I can think of are the anti-virus on the local system, or something that is loaded into memory on that system and hogging either memory or CPU cycles.
    Legare Coleman

  11. #11
    Star Lounger
    Join Date
    Jun 2005
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel time (2002)

    Cheers guys for your replies, i will get back to you tomorrow

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel time (2002)

    This seems to be yet another version of <post#=509,256>post 509,256</post: > by your alter ego <!profile=Skender>Skender<!/profile>. Please stop double posting,

Posting Permissions

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