Stump the Panel: SharePoint Q&A

Is it possible to rollup calendar entries from calendars in a site collection to the calendar in the top level site of the site collection? If yes, please explain cause I have spent many hours trying to get it to work. Also, if I use one color for each calendar will the color code follow? Thank you.

Out of the box, I don't think so. The opposite would be easier, have a central calendar and create filtered views for each sub-site.
You can roll up lists of events, using the Data View Web Part or the Content Query Web Part, but:
- this is a little bit complicated, especially if you have recurring events
- the aggregated list won't be rendered in the default calendar view

I also had this request from my customer. They wanted a master calendar that showed all of their team calendar events. You can also use this solution in reverse and populate the team calendar with events from other calendars. (our HR maintains the holiday calendar that is linked to each team calendar)

Here's what I did to accomodate:

1) Create a Master calendar - does not need to contain any events
2) For each sub-site that wants to contribute to the Master, create their own secured calendar
3) On the page you wish to display the Linked calendar, add a CQWP and point it to the Master calendar
4) Using SharePoint designer, open the page containing the Master calendar
a) In the Data Source toolpane, select Data Source Library
b) Under the Linked Sources section, scroll to the very bottom and select 'Connect to another Library' This is where you put in the url of the Site/SubSite that contains the 'to-be-linked-in' calendar (save)
c) Back up under the 'Current Site', go to the Linked sources and select 'Create a new linked source'
d) Give it a name under General
e) Under Source, click Configure..., change the Available Data Source to the site you linked in step c) and add the Calendar (repeat with other site calendars if necessary)
f) You'll also have to add the Calendar from the Current Site before the Finish button will appear.
5) Save and your new calendar should now be showing events from every calendar that's linked in.

Could you explain what you mean in step 3 by "point it to the Master calendar"?

Also, a side question: does this work with recurring events?

Thanks!

Christophe,

In step 1, a 'master' calendar is created. Use that same calendar when creating the Content Query Web Part.

I do have some reoccuring events, and it does display them as well.

Greg Appelt

ok, thanks Greg!