In previous posts I have discussed the concepts around the MOSS 2007 Membership functionality (see the Office 2007 and User Memberships post). This post talks about the location of the My SharePoint Sites and how it gets populated. Once again, the My SharePoint Sites functionality is new to Office 2007 and requires you establish your My Site prior to it actually functioning.

Location of My SharePoint Sites

The My SharePoint Sites folder gets created by any of the Office 2007 applications. The folder can be found in the following location:

C:\Documents and Settings\<Username>\Local Settings\Application Data\Microsoft\Office\

What populates the My SharePoint Sites folder?

The Office 2007 application suite is responsible for populating this folder. It will populate it based on what member groups you belong to within your SharePoint environment. Office will update this location once a day the first time you launch an Office 2007 application.

You can force an update of this location by deleting the following registry key:

HKCU\Software\Microsoft\Office\12.0\Common\Portal\LinkPublishingTimestamp

If you delete that above key and simply restart one of your Office applications, it will repopulate that folder based on what it thinks you are a member of.

SharePoint Administration Toolkit Batch Site Manager (BSM)