Excel Hang

Posted on 2014-08-11
Last Modified: 2014-08-24
I will like to ask,

my users are complain that there excel always hang when they are working on the file or when starting up the excel sheet.

This is just not 1 user but multiple users. I know that there open like 5 to 10 excel files simultaneously when working on any individual sheet. Is there a limit to that?

Each excel file could be contain just numbers and some contains lots of photo.

I am out of idea but their excel just keep on hanging.

Any advise?
Question by:patcheah
    LVL 23

    Expert Comment

    This is a very general question because there is no overview of the situation. And normally Excel doesn't hang but it takes quite some time to execute the current process, so patience will eventually work.

    First off, what are the specs of the machines you are using? Are these good enough to work with the calculations users are trying to do? Are these files on a network drive? Are there specific files the users have these issues with or do they even have these issues when creating new files?

    And Excel doesn't have a limit of open files (other than the max capacity of your machine) so i don't believe that being the cause. 5 to 10 documents open is not that much of a constraint on the machine.

    Author Comment

    Most of the users are using i5 or i7 with min 4GB ram. Some with 8GB ram also facing the same problem. All the files are located at local drive.

    I have waited for then 10-20 mins and the symbol still spinning.
    LVL 23

    Expert Comment

    What documents are they actually using?? Are these documents with a lot of links to maybe files on a network share? Otherwise i would first suggest to try and do a repair of Office as it seems there is an issue with Excel itself.

    How many CPU resources does Excel take up, all or close to none?

    Author Comment

    Well the cpu performance is running not more then 10 percent. No all the files and link are from the same worksheet located on the local hard drive.

    Even though new laptops are facing the same issue especially Dell laptops. Some of our users are running on toshiba and they do not encounter any problems.
    LVL 23

    Accepted Solution

    And all with the same Excel files?? This is very strange behaviour.
    What i have also seen to cause this behavior is links in Excel documents to locations that no longer exist but still it should be equally slow on both laptops, old and new. And you used the same installation methodology?

    Did the Office repair doe anything for you?

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site ( in my example), with minimal effort in Chrome and Firefox. I've seen a common theme a…
    Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
    This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
    This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    26 Experts available now in Live!

    Get 1:1 Help Now