How to Fix Excel Slow to Open in Windows 10
There can be various reasons for Excel slow to open on Windows 10 issue. Some of the plausible reasons are mentioned here.
How to Fix Excel Slow to Open in Windows 10 Method 1: Run Excel in Safe Mode Method 2: Update Microsoft Office Method 3: Remove Unwanted Formulas Method 4: End Other Processes Using Excel Method 5: Turn Off Hey Cortana Feature Method 6: Disable Problematic Add-ins Method 7: Disable Hardware Acceleration Method 8: Modify System Registry Additional Methods
Issues due to improper functioning of extensions and add-ins on Excel. Outdated or corrupt Microsoft Office version. Unwanted formulas on Excel sheets can also cause this issue. Issues due to interfering background processes. The issue caused due to Hey Cortana feature. The issue caused due to a problematic add-in. Issues caused by improper loading of graphics. The issue caused by improper Registry settings. Issues due to the Dropbox application. The issue caused by a file generated by a different software.
In this guide we have discusses methods to resolve Excel slow to open Windows 10 issue.
Method 1: Run Excel in Safe Mode
Often the issue can be caused by the extensions or add-ins used in Microsoft excel. If this is the case with your computer. You can avoid this issue by running Excel in safe mode. You can follow these simple steps to run Microsoft Excel in safe mode to fix Excel is lagging issues.
Press theWindows + Rkeystogether to open the Rundialog box.
Type excel /sand press theEnter key.
This willopen Excel in safe mode.If this does not fix Excel very slow to respond issue, try the next method to fix Excel running very slow error.
Method 2: Update Microsoft Office
Often the issue can be caused by an outdated version of Microsoft Office. When you have not updated MS Office in a long time, it can get various bugs and errors which can result in slow performance. You can try to fix this by updating Microsoft Office. Follow these steps to update Microsoft Office on your computer.
From the Start Menu, Open any of the MS Office apps for example,here open MS Excel.
From the top-left corner of the screen, click onFile.
(Video) Microsoft Excel Slow To Open - Load Faster [Tutorial]Now, locate and clickAccount.
Here, click onUpdate Optionsnext toOffice Updates.
Now, click onUpdate Now.
Follow theUpdate Wizard.
Follow the same steps for other MS Office Suite apps too.Also Read: How to Fix Move Excel Column Error
Method 3: Remove Unwanted Formulas
Unwanted or unnecessary formulas on your Excel sheet are one of the common reasons for Excel slow to open Windows 10 issue, if you are unintentionally leaving plenty of unused formulas like sumifs, countifs, and vlookups you may run into slow processing Excel. You can fix this issue by trying to convert these formulas to static values. Many users have found that changing these formulas to static values can fix Excel is lagging issue.
Method 4: End Other Processes Using Excel
If other background processes are using Microsoft Excel, it can drastically slow the Excel processes and cause various issues such as Excel very slow to respond issues. You can try to wait for these processes to finish and resolve Excel running very slow issue on its own. However, if you have an urgency to use Excel, you can try to kill all the background processes from the Task Manager. You can check out theHow to End Task in Windows 10guide to know the process of ending tasks on Windows 10.
Method 5: Turn Off Hey Cortana Feature
Many users found that when they turn on the Hey Cortana feature on their Windows 10 computers, they experienced lags and slowed processes with Microsoft Excel. Interestingly no other MS Office application experiences this issue but Excel. Therefore, if you have turned on the Hey Cortana feature it is advised to turn it off. You can follow these simple steps to turn off Hey Cortana on your computer.
Use the start menu, search forCortanaand click onOpen.
From the left side panel, click onTalk to Cortana.
Locate andTurn offthe toggle switch forLet Cortana respond to “Hey Cortana”.
(Video) Solve Microsoft Excel Slow To Open - Load Faster | How to Fix Microsoft Word & Excel Open Very Slow
Method 6: Disable Problematic Add-ins
Often the Excel Add-ins can be corrupt and cause various issues with the Excel files such as Excel slow to open Windows 10 issue. You can attempt to fix the Excel lagging issue by running Excel in safe mode. If there are no issues that occur in the safe mode then you should know the slowed issue with Excel was caused by a problematic add-in. Follow these steps to disable the add-in to fix Excel very slow to respond issue.
Firstly open Excel in safe mode as shown in Method 1.
Click on File.
Now, click on Options.
Navigate to the Add-inssection.
Here, uncheck all the Add-inson Excel and then clickOK.
Finally, restart the PC.If this does not fix Excel running very slow issue, try the next method.Also Read:Fix Excel stdole32.tlb Error in Windows 10
Method 7: Disable Hardware Acceleration
Sometimes the issue of slowed Excel is caused by improper loading of graphics. You can try to fix this issue by disabling the hardware acceleration feature on your Excel. Follow these simple steps to execute this method.
From theStart MenuopenMicrosoft Excel.
Locate and click on theFiles.
Now, navigate to theOptionstab.
(Video) how to Fix Excel Not Responding/ Freezing or Slow / hang issues in Windows 10Here, click on theAdvancedtab.
Scroll down and locatethe Displayoption and check the box forDisable hardware graphics accelerationoption.
ClickOKto save the changes.
Method 8: Modify System Registry
One of the methods to fix this issue is by making changes to the system registry. You can follow these simple steps to execute this method to fix Excel is lagging issue.
From theStart Menu,search forRegistry Editorand click onRun as administrator.
On the Registry Editor window navigate to the following location.
Double-click onthe (Default)key.
Clear theValue datasection and empty it.
ClickOKto save the changes.
If these methods do not work you can also use some additional methods to fix Excel very slow to respond issue. These methods are discussed in the following section.Also Read:How to Copy and Paste Values Without formulas in Excel
Additional Methods
The following are some of the additional methods that can be used to fix Excel slow to open Windows 10 issue on your computer.Method 1: Run Dropbox as AdministratorMany users who use Dropbox realized that it was Dropbox that was causing issues with the Excel files causing Excel running very slow issue. This issue can be fixed by setting Dropbox to run as administrator.
Hit the Ctrl + Shift + Esc keys together to openTask Manager.
Navigate to theStartuptab.
Locate and right click onDropboxand selectProperties.
Now, navigate to theCompatibilitytab.
Under theSettingsoptions click onRun this program as an administrator.
ClickApplyand thenOKto save the changes.
Method 2: Make Sure that Different Software Hasn’t Generated FileIf you are using another Excel-like software on your computer, you should make sure if the file you are trying to access is created by which software. Sometimes, when a user tries to open a file generated by different Excel-like software, they can find a slowed process with Excel.Q1. Why is my Excel running slow?Ans.There can be multiple reasons for Excel running slow on your computer. Generally, this issue is caused by corrupt extensions and add-ins.Q2. How to fix Excel issues?Ans.There are various methods to fix Excel issues, such as running Excel in safe mode, ending other background processes, disabling hardware acceleration, etc.Q3. Can formulas on my sheet cause Excel to slow down?Ans.Yes, if you have many unwanted or unnecessary formulas on your sheet, this may cause your Excel to slow down.Recommended:
How to Remove Popsocket Without Breaking Anything 3 Methods to Convert PDF to Google Sheets Difference Between Rows and Columns in Excel Fix Excel Has Run into an Error
We hope this guide was helpful to you and you were able to fix Excel slow to open Windows 10issues. Let us know which method worked for you. If you have any suggestions or queries for us please let us know in the comment section.
FAQs
Why does Windows 10 open Excel so slow? ›
- How to Fix Excel Slow to Open in Windows 10.
- Method 1: Run Excel in Safe Mode.
- Method 2: Update Microsoft Office.
- Method 3: Remove Unwanted Formulas.
- Method 4: End Other Processes Using Excel.
- Method 5: Turn Off Hey Cortana Feature.
- Method 6: Disable Problematic Add-ins.
Styles: When a workbook has too many cell styles, shapes, or formatting, it can cause Excel Online to take many times longer to open a file than usual. To see the cell styles for an Excel workbook, locate the Home tab, and then click the Down arrow in the lower-right corner of the Styles group.
How do I fix Excel from slow opening? ›- Open Excel in Safe Mode.
- Disable All Add-ins.
- Repair Microsoft Office.
- Remove Rules.
- Enable Manual Calculation.
- Replace Formulas with Static Values.
- Split a Big Workbook.
- Enable Superfetch.
- Avoid Volatile Functions (you must).
- Use Helper Columns.
- Avoid Array Formulas (if you can).
- Use Conditional Formatting with Caution.
- Use Excel Tables and Named Ranges.
- Convert Unused Formulas to Values.
- Keep All Referenced Data in One Sheet.
Click on file, Options. Go to the Advanced tab. Under the Display section, check the box for 'Disable hardware graphics acceleration'. Click ok and restart Excel.