21 August, 2013

To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser + SP2010


One of my user has opened a ticket by mentioning that he is facing some problems while opening excel files. Further probing stated that he has office 2010 already installed on the machine but still he is facing the problem.

Note: let me tell you that you might face the same problem with Office 2013 also.

User’s machine configuration:
Operating system: Windows 7 -32bit Version.
Office 2010 -32bit version.
IE 9 (internet explorer)-32 bit.

Error Message:
To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser.

Very important note: before starting any troubleshooting on this, make sure that your IE version should not be 64-bit.

Why?- Internet Explorer x64 is currently not an optimal approach since many Microsoft- and thirst-party ActiveX objects still do not support 64 bits. Office 2007/2010 does not ship 64-Bit controls for SharePoint integration, such as single document upload or multiple document upload, or "Connect to Outlook", "Open in Explorer View" and many more. Considering these limitations you may want to use the 32 bit version of Internet Explorer for the future to take benefit of the SharePoint integration features.

The required component / add-ons are simply missing for IE x64 and therefore causing several features not to function, being greyed-out or generate an [error] message once requested, such as "Message from webpage: The document could not be opened for editing"

Resolution:
Repair is a great Office tool that I have used in many previous versions of Office to fix things like the Normal.dot template being changed in Word, Outlook PST and email problems, etc. If Office 2013 is running slow or having some other issue, try performing a repair and hopefully it will fix your problem. Enjoy!

Here I will share the repair process for 3 different office versions i.e. Office 2010, Office 2013 and Office 2007.

If you are using Office 2010 then please try to repair by following steps:

1.   Click on Start and then Control Panel.
2.   After the Control Panel window opens, click on Uninstall a Program.
3.   A list of all installed programs should now appear. Highlight Microsoft Office 2010, and click on Change.
4.   After the dialog box loads, choose the Repair option and click Continue.
5.   This process may take a few minutes, but after completion, you will be prompted to exit and restart any open Office programs. You may then click Close.
6.   You may be prompted to reboot your computer to apply all changes and complete setup.

If you are using Office 2013 then please try to repair by following steps:
1.   To repair Office 2013, you first have to open the Control Panel and then click on Programs and Features.
2.   Click on Office 2013 and then click on the Change button.
3.   Next, click on the Repair radio button and click Next. This will start the repair process.
4.   It’ll take some time to repair and once it has finished, you’ll see a message saying the configuration of Office 2013 is complete.
5.   You’ll then have to restart the computer in order for the repair to complete.

If you are using Office 2007 then please try to repair by following steps:

1.   To begin, go to the Start Menu > All Programs > Microsoft Office > Microsoft Office Tools, and then click on Microsoft Office Diagnostics.
2.   After Microsoft Office Diagnostics opens, click Continue on the first page.
3.   By default, all of the diagnostic tests are enabled, so you may click on Run Diagnostics to proceed with diagnosis and repair.
4.   After running the diagnostics, a results page will be displayed.
5.   After clicking continue, your web browser will load with Microsoft's recommendations for the next steps to resolve any discovered issues with Microsoft Office.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Request: If you have any other resolution then please share so that it would be useful for the entire community. Thanks again!

2 comments:

  1. This solution worked for me on 08.25.14. -

    ReplyDelete
  2. This solution only worked for 1 day, then error returned

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge