User unable to edit SP documents (Excel in particular) by clicking on Edit Workbook -  Edit in Excel

Strange problem.. 

Site is on 2013 (it is hosted in Office 365) and the user is running IE9.  Just recently updated from IE8 where there was no problem.

The issue is when she browses to an Excel document on the site and then clicks "Edit Workbook" and then "Edit in Excel"  -  the window stating "We're opening your workbook in Microsoft Excel..." appears, but it never actually launches Excel.  She can then click on "Edit in Excel Online" and it works, but she prefers to work out of the Excel client.

IF she has the foresight to click the "..." on the document and chooses the option to Edit from there, the site launches Excel and she is able to work as expected. 

She has tried on multiple documents as well as on a document in her OneDrive.  All behave the same. 

I am able to launch this (also IE9 on a machine) without issue.   She is able to launch in Firefox/Chrome and it works.   Editing it online is just fine too, no matter which browser.  We updated the Office install to the latest version.

So the only trouble seems to be IE9, her machine, clicking the edit in excel option after you have opened up the work book.   The IE9 settings should be pretty standard for our company's build so why her machine is not working is not clear.

Any ideas on what to check or change?

April 29th, 2014 1:53pm

Hi Bill,

This issue is about the IE 9, it is a client issue. Please go to Internet Options->Programs->Manage add-ons, make sure all related SharePoint add-ons are enabled, especial for SharePoint OpenDocuments Class. If you cannot find the SharePoint add-ons, please repair the Office.

Please try to reset the IE, compare the result.

Please use IE 8 mode in IE 9, compare the result.

In addition, as this issue is about Office 365, you can also create a thread on Office 365 forum, more experts will assist you with Office 365.

Office 365 forum:

https://community.office365.com/en-us/f/default.aspx

I hope this helps.

Thanks,

Wendy

Forum Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

Free Windows Admin Tool Kit Click here and download it now
April 30th, 2014 3:29am

Solid advice.  I did notice a couple of things..

1- My IE9 which works does not have the OpenDcouments Class Add-on listed.  Hers did.

2- We can't reset IE (locked down)

3- testing it in compatibility mode worked.  Oddly we turned compatibility mode off and it continued to work.

The one thing we questioned was the installation of the latest version of Office that was done during the preliminary testing, similar to repairing from what I can see, but it was done without a reboot (never prompted, never crossed my mind) and after we finished but before I tested these things she had rebooted.  Perhaps that helped?

Either way it is working properly now. Thanks.

May 1st, 2014 7:39pm

Mine is also Same problem which is having Bill,

Solid advice.  I did notice a couple of things..

1- My IE9 which works does not have the OpenDcouments Class Add-on listed.  Hers did.

2- We can't reset IE (locked down)

3- testing it in compatibility mode worked.  Oddly we turned compatibility mode off and it continued to work.

The one thing we questioned was the installation of the latest version of Office that was done during the preliminary testing, similar to repairing from what I can see, but it was done without a reboot (never prompted, never crossed my mind) and after we finished but before I tested these things she had rebooted.  Perhaps that helped?

Either way it is working properly now. Thanks.


Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 2:30am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics