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!