Wednesday, June 22, 2011

After SharePoint 2010 upgrade–Excel Services does not work

After upgrading from MOSS 2007 to SharePoint 2010, I experienced the Excel Web Access web parts were no longer working and were producing the following error.

The workbook cannot be opened.

I turned all logging to verbose, and still did not receive any errors in the logs related to this.

After ensuring all of my farm settings were correct, I found another article of this being an issue with the service account for Excel Services not having the proper permissions on the databases. I have done many upgrades and never had this issue before. But with this being a DBA managed environment it was sure a possibility.

To fix it run the following PowerShell command on your SharePoint server granting access to your Excel Services account. It does require an IISreset, or at least did for me.

Add-PSSnapin Microsoft.SharePoint.PowerShell -EA 0

$webApp = Get-SPWebApplication http://WebApplicationURL

$webApp.GrantAccessToProcessIdentity("DomainName\ExcelServicAccountName")

SharePoint 2010 User Profile Import–How to filter only Enabled Accounts

When you create a User Profile Synchronization Connection in SharePoint, by default it will import all accounts in the containers you specify enabled and disabled.  If you only want to import enabled accounts, then after your connection is created add the following filter.

  1. Logon to Central Administration with a Farm Administrator account.
  2. Click on Manage Service Applications.
  3. Scroll down to and click on User Profile Service Application.
  4. On the Manage Profile Service page, click Configure Synchronization Connections.
  5. On the Synchronization Connections page, click the Active Directory connection that you want to edit, and then click Edit Connection Filters.
  6. On the Edit Connection Filters page, follow these steps:
    1. In Exclusion Filter for Users, change the Attribute drop-down to userAccountControl.
    2. In Exclusion Filter for Users, change the Operator drop-down to Bit on equals.
    3. In the Exclusion Filter for Users, select Filter box typeto 2.
    4. Click Add.
  7. Click OK.

Meeting Workspace links do not work after upgrade to SharePoint 2010

Links in a Meeting Workspace break after upgrading to SharePoint 2010. This is a known issue.

This is because Meeting Workspace sites have a different site template called MWSdefault.master in 2007. In 2010 it is MWSdefaultV4.master.  When you upgrade it needs to be repointed to MWSdefaultV4.master when you change to 2010 UI mode.

You can do this with SharePoint Designer, or you can go to a sub-site Site Settings – Master Page Gallery, and download a copy of MWSdefaultV4.master locally, then upload it to the Site Collection Master Page Gallery.  Then you can go back to your site and change it’s master page to MWSdefaultV4.master.

The URL for changing the site’s Master Page is /_layouts/ChangeSiteMasterPage.aspx .