Monday, September 16, 2013

SharePoint Error: To open this workbook your computer must have a version of Microsoft Excel


Recently, I was working with a user who experienced this error message when working with an Excel file in SharePoint: 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.

The week earlier, I had encountered a similar error on my own computer as well.

First, I wanted to check to see if the SharePoint Foundation Support for Office was installed (on my computer issue, this was not installed):
I clicked on the Windows icon (or the old Start button location) in the lower left hand corner of the screen, select Programs and Features.

The list of installed programs is displayed, scroll down to Microsoft Office Professional Plus 2010, left click on it once and on the menu bar select Change.



















Select the Add or Remove Features and then click Continue.

Scroll down and expand Office Tools. Ensure that Microsoft SharePoint Foundation Support is installed.
















Then Click Continue. Finally, click Close to complete the installation.

However, when I did this, the user still encountered the error.

In this case, the issue was the version of Internet Explorer being run. The user was running 64 bit version of Internet Explorer and these features are not supported in that version. Sometimes it is the simple things that cause the issue.

Tuesday, June 04, 2013

Share Office 365 SharePoint Site with External Users


One of the questions I get asked a great deal is how to share a SharePoint site in Office 365 with external users. This process has changed somewhat so this blog is my updated version which includes how to tie an external email address to a outlook.com address. This blog assumes that sharing has been enabled at the SharePoint Administration level.

1. Navigate to the SharePoint site that is to be shared with external users.

2. In the upper right hand corner, select the arrow next to Site Actions, then select Share Site:





 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
3. Enter the email account to share the site with in either the Visitors or Members selection. Select Share. Note: Visitors only get Read access to the site and Members have Contribute/Edit access to the site:
 


 
 
 
4. A confirmation message will appear stating that an email invitation has been sent to the user:
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
5. The user will receive an email invitation, like the one here. The user selects Accept your invitation:

 
 


 
 


6. At the following screen, the user selects Microsoft Account:

 

7. The user is then directed to the site:
 
 

 


 













Wednesday, March 27, 2013

Common SharePoint Issues - DataSheet View Not Working

Due to a series of SharePoint migrations, I have been out of the blogging world recently. These have completed and I plan on being able to actively participate in the Office 365 Community again. In my role, I have the opportunity to work with companies of all sizes ( from small business to enterprise). There are some common issues that I have come across no matter the organization size, so I thought I would begin documentint some of these "common" issues.

Issue:  DataSheet view tab not working (greyed out):


 

 
The users in this case are using Internet Explorer as the web browser of choice. Note: Internet Explorer is the recommended web browser. Not that Google Chrome or Firefox cannot be used but for all features to work properly, Internet Explorer is recommended.
 
Troubleshooting: Have the user check which version of Internet Explorer is being utilized to see if it is 64 bit. In the version of Internet Explorer I am utilizing, there is an options icon in the far right hand corner, select that and then select About Internet Explorer from the drop down list :
 
 

 
The About Internet Explorer dialogue box is displayed:
 
 
Please note in the version - 64Bit Edition is being utilized. Datasheet view does not work with 64 bit edition of Internet Explorer.
 
Solution: Ensure that the user runs the 32 bit version of Internet Explorer to access SharePoint. One way to ensure it is 32 bit is to select the Start button and type iexplore and then press Enter. This will launch the 32 bit version of Internet Explorer.
 
 
 
 
 
 
 
 


 

Wednesday, February 27, 2013

Internet Explorer 10 and Windows Explorer View SharePoint Online

Due to a large SharePoint migration, I have been out of the blogging world. Now that I have a little free time, I am back to writing. One thing that I am hearing today is in regards to Internet Explorer 10 and Windows Explorer view for SharePoint Online.

I am seeing many reports of open with Windows Explorer NOT working after users upgrade to IE 10. These same users report that if they downgrade to IE 9, it works without any issues.

Just be aware, if upgrading to IE 10 this functionality in SharePoint online may no longer work