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 another article Peter Kalmstrom, kalmstrom.com CEO and
Systems Designer, shows how
to create the Excel team calendar that he uses in the demo below.
Here Peter inserts the Excel calendar in the Excel Web Access
web part in a classic SharePoint
page. For a modern page, use the
SharePoint File viewer web part.
Insert an Excel calendar in an Excel Web Access web part in a classic SharePoint page:
- 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.