MS Office 2010: Excel Run Extremely Slow when Opening

Asked By Nina Marie 0 points N/A Posted on - 04/03/2012

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

• Status: Open
• Question Views: 4475
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Microsoft Office

Best Answer by Mclaughlin Jurgens

Go To Solution

Answered By Tanok Bloran 80 points N/A #115619

MS Office 2010: Excel Run Extremely Slow when Opening

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. 

About Tanok Bloran

Questions
2

Answers
315

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 04/04/2012
• Question Category: Microsoft Office

Best Answer

Best Answer

Answered By Mclaughlin Jurgens 0 points N/A #115620

MS Office 2010: Excel Run Extremely Slow when Opening

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.

• Download and install office 2012 file validation update from Microsoft

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

• Save the file locally on your computer and open it (if the file is stored on another networked pc)
• Upgrade to excel 2013 or downgrade to excel 2007
• Disable the OFV Add-in by using a registry setting

About Mclaughlin Jurgens

Questions
2

Answers
7

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 05/23/2013
• Question Category: Microsoft Office