MS Office 2010: Excel Run Extremely Slow when Opening

Asked By 0 points N/A Posted on -
qa-featured

When Excel 2010 try to open it seem very slow, how can it faster when it will open?

SHARE
Best Answer by Mclaughlin Jurgens
Answered By 80 points N/A #115619

MS Office 2010: Excel Run Extremely Slow when Opening

qa-featured

To fix lagging issues on MS Office Applications (Excel, Word):

  • Close the program
  • Click on Start
  • Choose Run
  • Type regedit
  • Hit OK
  • Locate and click on:

    • For Office 2003 (HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0CommonOpen Find)
    • For Office 2007 (HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0CommonOpen Find)
  • Click on New from the Edit menu
  • Choose DWORD Value
  • Type EnableShellDataCaching
  • Click on Modify
  • Type 1 in the Value Data box
  • Click OK
  • Click Exit from the File menu to quit the Registry Editor

If the steps above does not work, you may go to https://support.microsoft.com/en-us/help/833041/an-office-program-is-slow-or-may-appear-to-stop-responding-hang-when-yto click on the Microsoft Fix It button to have the issue solved automatically. 

Best Answer
Best Answer
Answered By 0 points N/A #115620

MS Office 2010: Excel Run Extremely Slow when Opening

qa-featured

To fix slow Microsoft office applications, try the following approaches:

  • Apply Microsoft hotfix as described in the following Microsoft article
  • check off the following registry key:

"HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0ExcelOptions"

Look for a WORD value labeled DisableRobustifiedUNC set to a value of 1. If this is set on your machine, it's recommended you delete this value or set the DWORD value to 0.

If the performance is still unsatisfactory, you could the following workarounds:

Related Questions