View original (French)

Slowness in Excel (processor usage: 12%)

Slivo -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,

I have a problem since today; the file I use every day has suddenly become extremely slow. It was working fine until yesterday, but today, every filter applied (for example) takes several minutes.
I went into the task manager, under processes, and the CPU is being used at 100% for that task, obviously blocking all my other Excel windows.

The file is quite large and has a lot of rows, and it runs a network query on our ERP every time the file is opened, but having tested it on other computers with pretty similar performance (4GB of RAM each, 3.40GHz processor on my machine and 3.50GHz on the others), the file opens normally for them. Just like it did for me yesterday.

So, could there be a reason why Excel is so slow?

Thanks in advance,
Slivo

Configuration: Windows 7 / Chrome 44.0.2403.155

1 answer

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    you should already test with a copy made on your workstation, to free yourself from any potential network issues.
    Excel or your file may not be to blame.
    eric

    --
    By continually trying, we eventually succeed.
    So the more it fails, the more chances we have that it works. (the Shadoks)
    Besides the thank you (yes, really, it's a thing!!!), remember to mark it as resolved. Thanks
    0
    1. Slivo
       
      Hello,

      Thank you for your response.
      I made a local copy, but unfortunately that doesn't solve the problem.

      However, I removed the automatic calculation, which saves me some time, but it's not practical since I'm trying to keep the file up to date.

      I tried again on the other workstation, with the task manager open on the performance tab to see if the PC was also experiencing a CPU spike however brief, but no, the CPU (all 4 in this case) continues to work normally, without any peaks. So, I don't know why they are saturating here...
      0
    2. rEVOLV3r Posted messages 223 Registration date   Status Member Last intervention   28
       
      Hello,
      So it's coming from your computer. Have you tried cleaning it? For example, CCleaner for temp files and the registry. It might be coming from there...
      We'll see.
      0
    3. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Raise the timer from end to end to detect the slow parts.
      Refine further when you've found the most resource-consuming part.
      eric
      0
    4. Slivo
       
      Hello,

      Thank you, I actually ran several scans on the PC last Friday (our antivirus, Spybot, Malwarebytes, CCleaner), but without success...

      What do you mean, eriiic?

      Thank you in advance.
      0
    5. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      Actually, I left thinking that you had macros, but maybe that's not the case.
      If so, break your program down into major phases.
      At the start of each phase, put:
      t = timer
      and at the end:
      msgbox timer - t
      You will have the time they take.
      Once you have determined the slowest one, do the same on it by breaking it down into subtasks to see which part slows down the whole, etc.
      That said, I am still convinced that there is a strong probability that your network requests may not be unrelated to the issue.
      Eric
      0