Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spreadsheet hangs

    Windows 95, Office 2000, 64 MB RAM: Large spreadsheet (located on network) is opened successfully by most users. Upon File/Open, for a handful of users, however, speaksheet loads -- as indicated by sliding indicator -- but hourglass remains for several minutes and system will either time out (Ctl-Alt-Del reflects not responding) or IPF occurs.

    Have applied SR-1 and backed off OLE update. Any other suggestions?

    One commonality is version of Netware client. Could this cause problems in Excel?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Spreadsheet hangs

    The Netware client can cause problems in anything! I assume you're running over a Novell network, or you shouldn't be running the netware client. Make sure everyone has the same version of the client, as well as having the same version of SR-1(a). Have your system administrator check to insure that network settings aren't causing the behavior on the problem machines.

    Also make sure that each machine has adequate room for its swapfile, since that can cause Excel (or any Office application) to hang up too. 64Mb of RAM is barely adequate for Office 2000, so you are probably page swapping when you load a large (what do you consider large, by the way?) spreadsheet. If the virtual memory settings and swapfile sizes are different on the different machines, that could cause the variation in behavior as well. If your hard disk is pretty full and/or heavily fragmented, that will affect the behavior on a particular machine.

    Unfortunately, tuning Office 2000 is something of an art or craft rather than a science, so you may have to provide more information to get a useful answer.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet hangs

    I've seen this behavior when the 'network' becomes sluggish. If you're 'failing' users have a slower network connection, this could be a problem. See if they can copy the file to their local harddrive and then try to open it from there.

  4. #4
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet hangs

    I have this exact problem here too..<font color=red>(See Corrupt Template...Jazman2001</font color=red>



    My scenario involved a very time consuming OCR prog that was loading via the VB Editor. r go to <font color=blue>Tools/Macro/VB Editor</font color=blue>
    [img]/w3timages/icons/yikes.gif[/img]
    Look in the left pane for unusual objects.

Posting Permissions

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