Forum Discussion
Converting excel data into a printable calendar template
tammyangel Perhaps you are willing and able to move away from Word, because you could do all within Excel, with Power Query / Power Pivot (provided you are working on a PC, not a Mac).
The attached workbook contains an example that demonstrates what's possible. Sheet1 contains the Events listing (Date, Event) and Sheet2 has a (power) pivot table with the Annual Calendar view you described. All don in a quick-and-dirty manner and most likely it needs to be adapted to your real situation.
Change the events listing (change a date, add, delete, rename), and refresh the pivot table. That's it!
Edit: Added another file ("tammyangel-2.xlsx) . Power Query only. Personally I prefer that one.
Hi Riny,
Do you have a solution for multi-day events? I am trying to implement the same concept for a year-long calendar of conferences and many are multi-day.
Thanks in advance!
sophiaperigee This is an old and long thread and many different calendar options were discussed. Perhaps better to start a new thread where you focus on your specific situation.