Office and SharePoint Metadata Synchronization

This article has been moved to:
http://excel.shilor.org/2010/07/office-and-sharepoint-metadata.html

Fixing static links upon migration from SharePoint 2003 to 2007

I have a post in http://excel.shilor.org/2009/08/fixing-static-links-upon-migration-from.html explaining how to make vertical changes to static links that wouldn't work after migrating to 2007 version because the new links are different.

The steps are:

• Export the list from SharePoint to Excel.
• Apply a formula that extracts the URL from its 'friendly name', which requires using a UDF (User Defined Function) macro.
• Apply the 'Copy' and 'Paste special' as values to replace the URL formulas with values. Use 'Replace all' to get the new URLs.
  **It is assumed that you know how to do that.
• Apply the 'HYPERLINK' formula to create the new links.
• Copy the new links back to the SharePoint list.

A detailed explanation is in the other post.

SharePoint 2010 Sneak Peek

Microsoft has just released 3 short clips for Users, IT Professionals, and Developers to get the feeling of what SharePoint 2010 will look like.

The user experience will be dramatically improved for all 3 target audiences.

Here is the link to preview the upcoming SharePoint 2010 release, expected in Q1 2010.

http://sharepoint.microsoft.com/2010/Sneak_Peek/Pages/default.aspx

How to limit a SharePoint user to view his list items only.

This article has been moved to:
http://excel.shilor.org/2010/07/how-to-limit-sharepoint-user-to-view.html