I have an .xls spreadsheet that updates perfectly from a sharepoint list on a internal website. This spreadsheet has rows of projects with several columns of projected dates(i.e.-projected install, projected training, ordered, etc...).



I am looking for the best way to view this information in a outlook shared calendar so that I can quickly know if I am scheduling too many projects on any given date. I do not have access to modify the SharePoint list. If putting this calendar into Excel is easier, I am fine with that.

What I need to populate on each specific date is the "Project Name" and column header. e.g.--if customer 1 had a projected install on 12/1 & training on 12/2; I would see "customer1 training" or "customer1 install"...or something similar.

Happy holidays all and thanks in advance.