Forum Discussion

David Migliore's avatar
David Migliore
Copper Contributor
Feb 04, 2018

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

Hi,

 

Ideally I’d like to:

  • Do data entry in an Excel spreadsheet
  • Create an Outlook calendar based on the Excel data (i know https://www.wikihow.com/Create-a-Calendar-in-Microsoft-Excel#Importing_an_Excel_List_into_Outlook_Calendar_sub 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

Excel calendar

1 Reply

Sort By
  • Alan Marshall's avatar
    Alan Marshall
    Iron Contributor
    Feb 04, 2018
    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.

Resources