Insert an Excel team calendar in SharePoint
A SharePoint tutorial by Peter Kalmstrom
SharePoint team site has its own calendar, but the team
can also share an Excel calendar via SharePoint. As it can
be color coded in Excel, it will look better than the inbuilt
SharePoint calendar – even if it does not have SharePoint
features like version history and alerts.
Each team member with contribute permission over the site
can edit the calendar, either in Excel or in Excel Online.
In the demo below Peter Kalmstrom, kalmstrom.com CEO and
Systems Designer, shows how to use the Excel Web Access
web part to insert an Excel calendar in a classic SharePoint
This is the process:
We have another Tip on how
to create the Excel team calendar used in the demo above.
- Save the Excel calendar to the SharePoint site where
you want to share it.
- Define how much of the workbook should be displayed
- Open the SharePoint page where you want to place
the calendar in edit mode and insert the Excel Web Access
- In the web part tool pane, set the web part to use
the Excel calendar.
Also refer to
the kalmstrom.com Blog post about team calendars.