The mystery of Excel’s Calendar Creator template

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Excel has a Calendar Creator template which might work or might not.  Why it doesn’t work is a mystery.

The ‘Calendar Creator (any year’) template sounds great … a one-page year calendar.

the mystery of excels calendar creator template microsoft office 33588 - The mystery of Excel’s Calendar Creator template

Find it from File | New then search for calendar creator.

When the template is opened, it should display a calendar for the current year.

the mystery of excels calendar creator template microsoft office 33589 - The mystery of Excel’s Calendar Creator template

Change to another year by typing another value into the cell.

the mystery of excels calendar creator template microsoft office 33590 - The mystery of Excel’s Calendar Creator template

If all goes well, you’ll get a full year calendar.

the mystery of excels calendar creator template microsoft office 33591 - The mystery of Excel’s Calendar Creator template

That’s the theory …

Or that’s the theory.  On some Excel 365’s the calendar creator doesn’t work!

We don’t look for bugs in Office, they find us!

Several readers have confirmed our experience where the same template doesn’t work.  No matter what you do, the dates don’t appear properly.  February 2019 does start on a Friday, but not in the fifth week.  Traditionally February has 28 or 29 days, not 9 <g>.

the mystery of excels calendar creator template microsoft office 33592 - The mystery of Excel’s Calendar Creator template

What’s the difference?  Good question with no clear answer.

For us, the difference is between the latest public release and the most recent Insiders version.  Office Watch readers have also reported problems with the public release.

All you can do is try for yourself.  The problem will show up as soon as the template is opened.

If the dates for April are empty, you’re out of luck.

the mystery of excels calendar creator template microsoft office 33593 - The mystery of Excel’s Calendar Creator template

We tried opening the template in Excel Online but it would not open.  A workbook from the template can open in Excel Online (as it should) but with the same error.

What’s the problem?

Something about the February calculation is the problem.  Because the template doesn’t get February right, the rest of the months are messed up.

We had a look at the code but there was no obvious fix.  If you can figure it out, please let us know so we can share with others afflicted.

subs profile e1563205311409 - The mystery of Excel’s Calendar Creator template
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address