View Single Post
 
Old 12-07-2011, 08:12 AM
ReviTULize ReviTULize is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Dec 2011
Posts: 20
ReviTULize is on a distinguished road
Default Outlook Shared Calendar from Excel

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.
Reply With Quote