Link an excel calendar to Outlook shared mailbox calendar

alex614

New Member
Joined
Jan 10, 2022
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Good morning.

I have been asked by my boss to link our calendars so we aren't entering double the data across two calendars.

We have an excel calendar used for job details and an outlook shared mailbox calendar used for team appointments and taskings etc.

So they want, if possible, to link the excel calendar to the shared mailbox calendar so if a job in input onto the excel sheet it will auto populate the Outlook shared mailbox.

Is this possible? And if it is, how do i go about linking them.

I found a page on how to link them by saving the spreadsheet as a CSV file and import/exporting that file in Outlook to the calendar location but that did not work and i could not select shared calendar either.

I have attached an image of the excel calendar to show its format.

Thanks in advance.
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    104.9 KB · Views: 25

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,214,785
Messages
6,121,543
Members
449,038
Latest member
Guest1337

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top