Solved Why is Excel 365 so slow?

Microsoft Microsoft office 365 home prem...
February 4, 2017 at 02:35:21
Specs: Windows 64, i5-4590 @ 3.5ghz
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.


See More: Why is Excel 365 so slow?

Report •

✔ Best Answer
February 4, 2017 at 13:00:13
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
February 4, 2017 at 05:41:03
This maybe able to help - http://winsupersite.com/windows-10/...

hope you found a solution. please reply if so
happy to help
Lakshan Costa


Report •

#2
February 4, 2017 at 06:24:17
"I have huge amounts of available ram and a very fast desktop pc"

It would help to post the specs & make/model of your system. Also, there is no "Windows 64". I'm guessing you have a 64-bit version, but is it XP, Vista, 7, 8, or 10? When's the last time you ran a cleaner & scanned for viruses & malware? If you have a store bought computer (Acer, Dell, HP, etc), have you ever taken the time to remove the bloatware & disable unnecessary startup apps?

CCleaner (get the Slim version): https://www.piriform.com/ccleaner/b...
Adwcleaner: https://www.malwarebytes.com/adwcle...
JRT: https://www.malwarebytes.com/junkwa...
Malwarebytes Antimalware: https://www.malwarebytes.com/


Report •

#3
February 4, 2017 at 07:44:52
It's my understanding that Office 365 is a subscription plan
and that you access the software over the web.

If this is correct, it could be your web access is slow.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
February 4, 2017 at 07:48:09
Also, just checked your specs, and it show you have Excel 2013 also.

Having two version can sometime confuse the program, might try
uninstalling the 2013 and see if it helps.

MIKE

http://www.skeptic.com/


Report •

#5
February 4, 2017 at 07:54:58
I added the basic specs into the original post. I'm really looking for people to help who have a more thorough understanding of Excel / Office and what may be causing the problem on that level. There is no need to be rude riider.

I know how to optimize the pc in general so that it runs fast for other tasks including adjusting the startup in msconfig, defragmenting hdd, removing context menu entries which slow things down etc. I don't allow anything to use too much CPU or ram that I don't need. The CPU is at 99% idle, ram shows as 4500mb available, 2225mb free memory, 3500mb in use from task manager.

More detailed specs:

Windows 7 64bit Professional (build 7601 SP1)
Sapphire PCI Express R7 260X 2GB Graphics Card (OC GDDR5, HDMI, DVI, DP, 2S)
Intel HD graphics 4600
1TB hdd
Sandisk 240Gb SSD
Intel i5-4690 Haswell Refresh 3.50ghz
HyperX 8gb 2400mhz CL11 DDR3 HyperX Beast
Gigabyte GA-Z97M-DS3H rev 1001 (1.1)
Coolermaster 650w GX

BTW I deleted the old version of Office already in case that was causing problems as you say mmcconaghy but it hasn't helped.

message edited by Adamantus10


Report •

#6
February 4, 2017 at 08:24:35
re: "There is no need to be rude riider."

I see nothing rude in riider's response.

He correctly pointed out that there is no such thing as Windows 64. He could only work with what you posted, so he simply pointed out a piece of information that was not usable and asked for clarification.

He then asked a series of relevant questions related to your PC.

He ended his post by graciously offering 4 links to utilities that might help you solve your issue.

You came to this forum asking for help and riider correctly, and in a friendly manner, offered some suggestions - in the form of questions - that have helped others many times in the past.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#7
February 4, 2017 at 08:32:46
I've been having issues using Excel recently.

So what did you change in your system?
It could be something as simple as adding new software.
There was a bug, not long ago, where having Skype on your system screwed up Copy&Paste in Excel, so if you have added software try removing it.

Does the slow down happen on all spreadsheets or just a specific one/few ?

Does it happen in a brand new sheet or only on older ones?

MIKE

http://www.skeptic.com/


Report •

#8
February 4, 2017 at 08:41:19
DerbyDad03 he quoted me and then brought into question everything I had said. I found your post pretty confrontational as well but I didn't come here for that, I just want to get some help on my excel issue.

mmcconaghy I didn't really change anything as such, this has been going on for a long time. I did move from Office 2013 to 365 but did remove the old version. It seems to be Excel configuration issues rather than PC configuration issues.

message edited by Adamantus10


Report •

#9
February 4, 2017 at 11:19:45
re: he quoted me

I quoted you also. Mike quoted you too. This is done only as a means of reference. This forum does not have a "quote original" feature like many other forums do, so the only way to address specific points is to quote them manually. I don't see that as confrontational, I see that as trying to be clear and making sure that everyone knows which points are being addressed.

re: and then brought into question everything I had said.

Please show me where he questioned anything you said other than the Windows 64 spec.

You said that you "tried disabling all Add-ins but that hasn't helped."

riider then asked a series question not related to add-ins. He asked about bloatware, startup apps, viruses and malware. That is not questioning anything you said, it is simply asking for more information and offering well founded suggestions. Each of those items, and indeed the add-ins that you disabled, can cause poor performance. He didn't question anything you said you tried, he merely expanded on the possible causes for your issues.

Neither riider nor anyone else in this forum is sitting next to you at your computer. If all you tell us is that you disabled add-ins, how would we know "when's the last time you ran a cleaner & scanned for viruses & malware" or if you have "ever taken the time to remove the bloatware & disable unnecessary startup apps for a store bought computer"? The only way to determine that is to ask.

Mike asked you a couple of very valid questions also. Why do you not find his questions confrontational? Why don't you find this question confrontational:

"So what did you change in your system?"

Doesn't that make you feel that he is accusing you of causing the problem? I doubt it does, because it shouldn't, just like none of riider's questions should make you feel like he is questioning your expertise.

re: I found your post pretty confrontational as well but I didn't come here for that, I just want to get some help on my excel issue.

Then I will have to assume that you found this post confrontational also, but there is nothing I can do about that. Everyone in this forum is here on volunteer basis. riider took the time to ask some very valid questions about the status of your system and you attacked him. If anyone should feel "confronted", it's riider, not you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#10
February 4, 2017 at 13:00:13
✔ Best Answer
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/


Report •

#11
February 4, 2017 at 13:38:20
DerbyDad03 I don't want to fall out with anyone but sometimes people seem to want to pick holes in things instead of actually make some well-informed suggestions.

mmcconaghy No error messages it just seems to pause when clicking a cell and then the cell is finally highlighted around 5-8 seconds later. I suppose it could be trying to talk to Microsoft (not something I want it to, no interest in its cloud features). I'll try what you suggest about ensuring the cells are deleted but I'm not sure there is any stray data anywhere. The workbook has 3 sheets and only 1 has a lot of data in it. It's mainly composed of simple formulas going from columns A-L and rows 1-112.


Report •

#12
February 4, 2017 at 13:56:33
In addition to Mike's fine suggestion, you could also try this simple macro:

Sub HowBig()
 UsedRange.Select
End Sub

If anything other than your expected range of data is selected, then you might have a single cell way off someplace that is/was formatted differently or contains hidden data.

If you find that to be the case, then you'll need to delete the extraneous Rows/Columns and then save and reopen the file as Mike details.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#13
February 4, 2017 at 13:58:45
re: ...make some well-informed suggestions.

Which is exactly what riider did.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#14
February 4, 2017 at 14:16:05
re: "The workbook has 3 sheets and only 1 has a lot of data in it. "

"The" workbook?

Is this only happening in one workbook? In your OP you said: "I've been having issues using Excel recently"

Please clarify this for us. Is your slow response common to any and all workbooks or just to "the" workbook that you mentioned in your latest response?

The more information we have, the better we can offer well-informed suggestions.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question