This issue can sometimes be caused by an OS level service named “Superfetch” being disabled. Superfetch is responsible for caching the data on the RAM so that, as the name indicates, it can be fetched super-fast when required. A key point worth mentioning here is that enabling it can cause you problems while gaming, but it works pretty nicely with business apps like Excel and Outlook etc. If you don’t think that enabling Superfetch is the way to go then there is another method that we will be sharing and you can try that (Method 2).
Method 1: Change Superfetch Settings
Start the Superfetch service, by Holding the Windows Key and Press R. Type services.msc and click OK. Locate the superfetch service, right click on it and choose Start.
If it won’t start for any reason, then follow the steps below. Press the Windows key and type “regedit” in the search area. The registry editor should open. Expand the HKEY_LOCAL_MACHINE Now click on “SYSTEM”. Then expand “CurrentControlSet”. Now click to expand “Control”. Then click on “Session Manager”. Then “MemoryManagement” Finally click on “PrefetchParameters”. Now on the right hand side, you should see a field named “EnableSuperfetch”. Type “1” in the value field to enable prefetching when programs get launched. Alternatively, you can set “0” to disable it; “2” to only enable boot prefetching and “3” to enable prefetching of virtually everything. Click on OK now and close the registry editor. Now we have to open the services MSC. To do so, type the windows key and type “services.msc” before pressing Enter. Now, in the services window, scroll down until you find “Superfetch”. Right click on it and select
Method 2: Modify Registry for Excel
If the method above didn’t work for you, then you can follow these steps: (Note: This method isn’t the cleanest as it involves deleting some subkey values but it does work so can be tried) Once again open the registry editor by pressing the windows key and typing “regedit” in the search area, before pressing Expand HKEY_CLASSES_ROOT. Then click on “Sheet.12”. Now expand “Shell”. Then click on “Open”. Finally click on ‘Command”. On the right hand side, you should see a subkey by the name (Default). Double click on it and change its value to: “C:\Program Files\Microsoft Office\Office15\EXCEL.EXE” “%1” (Note: If your Office folder isn’t located in the path specified above, you can change it. For example, use “Office14” instead of “Office15” used above). Delete the “command” subkey which should be present right beneath (Default). Turn your sight back to the left hand side and you will see a key named “ddexec”. Delete it as well. Close the registry editor. Your excel files should now open a lot faster than they previously did.
How to Save Specific or Selected Excel Columns as a .csv FileFIX: Cannot Preview EXCEL Files in Outlook 2016Fix: Outlook 2016 Freezes When Previewing Excel FilesHow to Fix Microsoft Publisher won’t Save Files as PDF
