computing
  • 0

Solved Why is Excel 365 So Slow?

  • 0

I have Microsoft Office 365 ProPlus and I’ve been having issues using Excel recently. I’m not trying to do anything fancy, literally just colour text, make it bold, do basic sums on it. But it can take around 5-8 seconds just to make a cell’s text red for instance. Why is this?

I have huge amounts of available ram and a very fast desktop pc. I’ve tried disabling all Add-ins but that hasn’t helped. Surely computers should be able to do basic things like colour text and do basic sums with ease. BTW I’m just using =B1*C1 or =sum(B1:B10), no macros etc.

Share

1 Answer

  1. Without knowing how big and/or complex your sheets are, these are the usual
    suggestion to help speed things up:

    https://support.microsoft.com/en-us…

    You should also try cleaning up empty columns & rows.

    Go to the first completely blank column at the right of your data.
    Select the column by clicking on its letter.
    Hold Shift+Ctrl and then hit the right arrow key until you have selected all the way out to Column XFD.
    Right Click with your mouse, and select Delete.

    Do the same thing with Rows
    Go to the first completely blank row at the bottom of your data.
    Select the row by clicking on its number.
    Hold Shift+Ctrl and then hit the down arrow key until you have selected all the way down to Row 1048576.
    Right Click with your mouse, and select Delete

    Save the file.

    Have you received any error messages or is it just a general slow down?

    MIKE

    http://www.skeptic.com/

    • -1