Excel lag

Question

Does anyone have any answers or suggestions on why Excel lags from cell and to cell? Besides the data fill in each cell is slow, when I choose a cell across the page the cell outline floats across the page. I have worked several hours in Excel and have had to take Dramamine a twice to keep nausea at bay. After all the troubleshooting and checking computer usage and specs, my conclusion is the program. Again, any answers or suggestions would be helpful.

Answer 1

Try following one by one as check after every step whether it resolves the issue-

1. Try repairing your office installation. First try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)

https://support.office.com/en-us/article/Repair...

2. Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

Now open Excel and see if the problem disappears or not.

Note - If the above path is not applicable for your installation, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)

Open Excel > ALT+F11 > If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window > Type "? application.StartupPath" without quotes and press enter > You will have your path below.

3. Sometimes, add-ins can cause problems. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away.

To start in Safe Mode -

Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation.

If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in.

To disable add-in > File > Options > Add-ins > Down below you have Manage: Com Add-in : Press Go > Untick the Add-ins to disable and tick to enable them

4. Try to login through another Windows profile. If there is some corruption in profile which is causing this problem, this would correct.
5. Sometimes, this is caused due to excel not being able to access the default printer. Close all office applications and change your default printer through Start > Devices and Printers to another printer. It may be some physical one or One Note or XPS or PDF or anything else. If this is the problem, then you will need to update your printer driver for default printer.
6. Many third party applications also cause the problem like Tuneup Utilities, Abby Finereader, Kaspersky Anti Virus etc. If you want to know if some program is conflicting -

Boot your computer in Clean boot mode and then start Outlook. If it works successfully, then some program is conflicting with this.

Refer to the section - How to determine what is causing the problem after you do a clean boot.

Don't forget to do - Reset the computer to start normally after clean boot troubleshooting.

https://support.microsoft.com/en-us/help/929135...

7. You may try to disable the Hardware Graphic Acceleration and verify the result:

Open Excel > File > Options > Advanced > Under the Display section, check the box for 'Disable hardware graphics acceleration' > Click Ok and restart Excel.

Answer 2

When 2013 was first released it was like that too. Excel specifically was so slow that I uninstall Office 2013 after using it for less than an hour.

There are a couple of known fixes for this issue. Give them a try

OFFICE 2016 SLOW, LAGGY - OUTLOOK

Office 2016 - relatively laggy and slow. Is this expected?

FYI: My Outlook 2016 slowness issue was found to be due to the AVG addin. I’ve temporarily disabled it and the performance issue went away. Note I didn’t have this performance issue with Outlook 2013 and the AVG addin.

You gave me the right direction. After removing the Cloudmark plugin Outlook 2016 speed returned to normal.

Same here. In my case, antispam was provided by BitDefender. I’ve disabled the addin and also disabled antispam in BitDefender’s console.

OFFICE 2013 SLOW - TURN OFF ONEDRIVE SYNC

<snip>

Perhaps uncheck the “use Office to sync files faster...” setting in Onedrive.

Reference: http://answers.microsoft.com/en-us/office/forum...

I looked at the Settings of the Onedrive desktop application and I saw that the option “Use Office to sync files faster and work on files...” was checked. I unchecked it and everything went normal, my CPU is now under control and there’s no CSISYNCSLIENT.EXE process in the background... Somehow, this started when I used OneNote via Outlook 2013 for the first time.

What this process does is build a very large cache of indexed Office files on your local drive. For me, the cache was ~5GB, or about equal to the combined size of my Office files. That would be fine provided I had extra space available on my SSD, but I don’t.

I discovered that simply turning off this option does not automatically delete the cache and free the space. To recover the disc space I closed the Onedrive application and then deleted everything in C:\Users\UserName\AppData\Local\Microsoft\Office\15.0\OfficeFileCache. Keeping the “Use Office” option turned off has resulted in a much smaller cache.

MS needs to document the cause/effect of this option so people understand the impact it has on their system.

</snip>

EXCEL SLOW

Turn off Hardware Acceleration

Answer 3

I'd suggest trying to uninstall Office first and then reinstall it.

The easy fix tool in Option 2 of the link is the suggested method.

https://support.office.com/en-us/article/uninst...