Error Opening Excel 2007 and 2010 Documents in SharePoint 2010

Last night we completed a SharePoint 2010 at work and after all the testing, we deemed the upgrade a success, however coming into the office this morning, we received reports from some users that they were unable to open some of their Excel spreadsheets stored in various Document Libraries.

After some diagnosis, it turned out that the problem only effected Office 2007 and Office 2010 XML format documents and that original format Excel documents from Office 2003 and documents saved in the 2003 format were unaffected.

After initially suspecting the problem to be linked to the new Excel Services Application in SharePoint 2010, I worked to resolve the configuration of the Excel Services Application which we had left previous un-configured due to it not being required currently, however the problem persisted.

Whilst searching TechNet for the error code we were receiving I encountered a page entitled “Configure the Default Behaviour for Browser-Enabled Documents” (http://technet.microsoft.com/en-us/library/ee837425.aspx) which details how to manage the behaviour of SharePoint for launching web compatible documents.

SharePoint 2010 features various web-enabled services and can be configured to use Office Web Apps, which is a hosted version of the applications available via Office Live WebApps. The default behaviour for SharePoint 2010 is to attempt to launch web compatible formats using the web based application, however as this is not configured in our environment the error appeared.

The resolution to the problem was simply enabling the Site Collection Feature Open Documents in Client Applications by Default. Once enabled on the Site Collection to apply the setting to all child sites, SharePoint began prompting the users to open the file with their client side installations of Excel as per the SharePoint 2007 behaviour.

Roll on the Release Candidates

Well Microsoft have certainly been busy little bee’s with Windows 7 as a lot of my recent blogs show, but today is the next milestone and not just for Windows 7.

Microsoft today released Windows 7 RC, Windows Server 2008 R2 RC and also the Service Pack 2 for Windows Vista.

Vista users using RTM with the blocker tool will be disappointed to note that this tool has now been removed and will have to upgrade to SP1, however I personally think you should just go all the way to SP2.

Going along with the whole RC & SP release, last week also saw the release of Office 2007 Service Pack 2 which has a lot of stability and performance improvements, which for some will be welcome although I never really see any problems except perhaps in Outlook opening a huge attachment.

Windows 7 RC is available in x86 and x64 builds and is available currently to all TechNet and MSDN subscribers, as is Server 2008 R2 RC, however Windows 7 RC will be making it’s way to the public in the next few days.

Office 2007 Service Pack 2 and Windows Vista Service Pack 2 are both available from the the Microsoft Download Center at www.microsoft.com/downloads.

Have a great weekend.