Create an Outlook Calendar (from Excel) that auto-refreshes when the Excel file is updated

Copper Contributor

Hi,

 

Ideally I’d like to:

  • Do data entry in an Excel spreadsheet
  • Create an Outlook calendar based on the Excel data (i know how to do this)
  • Calendar is auto-refreshed whenever the Excel file is updated

I don't know how to do that last bullet: auto-refreshing the calendar when the Excel file is updated.

 

If this can't be done with an Outlook calendar, is it possible to do it with another kind of calendar, like one that's built-into Excel?

 

Thank you

Dave

1 Reply
Have you looked at using Flow? You can created a schedule Flow to loop through the rows in the spreadsheet, find new ones based on some created date and then create a calendar item basses on the column details.