Wednesday 28 October 2015

SharePoint 2010: Microsoft Excel has stopped working: A problem caused the program to stop working correctly. Please close the program.

Microsoft Excel has stopped working: A problem caused the program to stop working correctly. Please close the program.


Error Screenshot:


Solution:
1. Delete the Temporary Internet files, Cookies and website data, History, Download History, Form data, password, Tracking Protection.
2. Add the SharePoint site URL into Trusted sites list.
3. Modify the IE browser settings in the Security Settings.

Explanation:
1. Delete the Temporary Internet files, Cookies and website data, History, Download History, Form data, password, Tracking Protection.
  • Open the IE browser --> Go to Tools --> Internet Options --> in General tab, find the Delete.. button.
  • Click the check-boxes: Temporary Internet files, Cookies and website data, History, Download History, Form data, password, Tracking Protection.
  • Click Delete button to delete the selected items. (see the below screenshot)
 
2. Add the SharePoint site URL into Trusted sites list.
  • Open the SharePoint site with IE browser.
  • Go to the Tools menu in the IE browser --> In the drop-down menu, select Internet Options.
  • Go to Security tab --> click Trusted sites --> click Sites button.
  • Add the SharePoint site URL in the place ‘Add this website to the zone’.(Ignore if the site URL is automatically present in the box)
  • Un-check the box ‘Required server verification (https:) for all sites in this zone’ --> click Add button click Close button to close the windows.




3. Modify the IE browser settings in the Security Settings.
  • Open the SharePoint site with IE browser.
  • Go to the Tools menu in the IE browser --> In the drop-down menu, select Internet Options.
  • Go to Security tab --> click Trusted sites --> In the bottom, see and click Custom level.. button.

  • Under the ActiveX controls and plug-ins --> find the Allow Scriptlets --> Enable it.

  • Under the Miscellaneous section --> find the Access data sources across domains --> Enable it.

  • Under the Miscellaneous section --> find the Display mixed content  --> Enable it.

  • Click OK and YES and OK to come out from the IE browser options window.
  • Close the IE browser and re-open the IE browser and login to the SharePoint site and try to open the Excel, Word documents stored in your SharePoint site.
Hope the issue got resolved by following these steps...!!!

No comments:

Post a Comment