14 September, 2013

connect to office disabled in sharepoint 2010

Connect to office is a very vital feature if you are working with lots of libraries and lists. One of our users reported an issue that he is not able to use the ‘connect to office’ drop down menu.

Desktop entities:-
Windows 7 OS
IE 9 32-bit
Office 2010 32-bit
SharePoint Server 2010

Problem description was not clear so further probing, we came to know this option is disable/greyed out. Strange! No ideas as I have never used this functionality before the issue actually reported to my team.

I started my research by learning the default functionality:

Issue description:-
Connect to office disabled / Connect to office disabled is greyed out.

Error message:-
Connect to office, this control is disabled.

Before you start troubleshooting on this issue, make sure that you have enough set of permission to perform this activity.

Troubleshooting done:-
1)   Cross-checked the office version is 32-bit or not. It should be 32 bit only and not a 64-bit.
2)   Cross-checked the IE version is 32-bit or not. It should be 32 bit only and not a 64-bit.
3)   Tried opening the SharePoint site in Mozilla Firefox as well as Google chrome but same results i.e. option is disabled.
4)   Repaired the office version but that didn’t resulted any success.
5)   Tried enabled-disabling add-ons in internet explorer but no success
6)   Tried adding the SharePoint site in trusted location by means of IE but still no results.
7)   Checked on different desktops who were using IE 7, 32-bit as well as Office 2013, 32 bit but no results

After the exhaustive troubleshooting for hours then I got the following article and I wanted to convey my Million Thanks to Mr. Brian for sharing this valuable information with all of us: http://mywinsysadm.wordpress.com/2011/07/28/sharepoint-connect-to-office-for-new-document-creation

As per this article- MySites must be configured with the Use Personal Features permission turned on.  You can enable this by going into the Central Administration Console, click on Manage Service Applications, click the link for the User Profile Service Application, and select Manage User Permissions.

That’s it. I got the direction, followed as per the mentioned instructions and the issue has been comes to an end. Happy SharePoint!

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.

1 comment:

  1. Quick Question, what do you do if the Icon for Connect to Office, is not there at all? SP2010, Office 2013 (32bit), Windows 7 Ent 64 bit. IE 11


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