Paul Galvin's (old) SharePoint space [SharePoint

Just another site

SharePoint Does Not Provide Calendar Roll-ups; Potential Solutions

UPDATE: An anonymous person in the comments posts this link:

Forum users often ask a question like this:

"I would like to have a calendar at the site level that is populated by events from subsite calendars.   Ideally, users in subsites will create calendar events, and will have the option of marking them as ‘public.’  Events marked as public will dynamically appear in the shared site calendar.  Thus the shared site calendar is a roll-up of all public events from all subsite calendars."

Is WSS 3.0 or MOSS 2007, it is not possible to directly configure a "roll-up" calendar.  Calendars exist on their own, independent of any other calendar.

To create a roll-up calendar, follow one of these paths:

  1. Use a Content Query Web Part.  This is the easiest solution for MOSS users (WSS does not provide CQWP).  CQWP, unfortunately, does not provide a calendar view of data out of the box.  It does provide enormous rendering flexibility (see here for one example) but by default, shows its results in simple list format.  In many cases, CQWP probably a good choice.
  2. A more programming-oriented solution would be to use event receivers.  Implement event receivers on the subsite calendars that keep their public events in sync with the master calendar.  As a given subsite calendar is modified, reach out to the master calendar and update it as needed.  This option is available in both WSS 3.0 and MOSS.

There are probably other clever solutions to this problem.  If you have one or know of one, please leave a comment or email me and I will update this post.


Technorati Tags: ,

Subscribe to my blog.


4 responses to “SharePoint Does Not Provide Calendar Roll-ups; Potential Solutions

  1. sercan March 16, 2008 at 10:59 am

    have a look this link has "Consolidated Calendar web part"

  2. Paul March 16, 2008 at 11:03 am

    Thanks for the link!  Looks interesting.

  3. Unknown March 17, 2008 at 12:07 pm

    We are using some solutions from Bamboo to achieve this effect problem is they\’re a little pricey for the average client.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: