Home >Tips >Insert Excel calendar in SharePoint kalmstrom.com site map icon Site map  

Insert an Excel team calendar in SharePoint

A SharePoint tutorial by Peter Kalmstrom

Excel iconA 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 page.

This is the process:
  1. Save the Excel calendar to the SharePoint site where you want to share it.
  2. Define how much of the workbook should be displayed in SharePoint.
  3. Open the SharePoint page where you want to place the calendar in edit mode and insert the Excel Web Access web part.
  4. In the web part tool pane, set the web part to use the Excel calendar.



We have another Tip on how to create the Excel team calendar used in the demo above.

Also refer to the kalmstrom.com Blog post about team calendars.



Learn more


Office 365 from Scratch cover SharePoint Online from Scratch cover SharePoint Online Exercises cover
     
SharePoint Workflows from Scratch cover Excel 2016 from Scratch cover SharePoint Flows from Scratch cover







Always the latest news in the kalmstrom.com blog


Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!

Products Buy FAQ Services Tips Books Contact About Us Blog

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved