Cannot change year in new calendar template

Robert Bourgeois 0 Reputation points
2026-04-06T20:52:08.1966667+00:00

Cannot create calenders for future years in word or excel

Microsoft 365 and Office | Word | For business | Windows
0 comments No comments

Answer recommended by moderator
Charles Kenyon 170.7K Reputation points Volunteer Moderator
2026-04-06T22:18:44.6433333+00:00

You are correct. Microsoft simplified its Word templates. Jay has given you information about how to do this in Excel.

Microsoft used to have macro-enabled templates for Word that let you set the year or month and have the dates adjust. The information for some templates still refers to the Calendar tab. That tab has vanished from those templates, though. They have stopped offering those, perhaps because people were afraid of the macros.

User's image

Per Bob Jones, apparently, in the Mac interface, the template named "Calendar" also still contains the macros and the Calendar tab as in the description.

If you have used a macro-enabled template from Microsoft in the past for this, it should still be on your computer in the folder you have designated as the default location for saving custom office templates.

When you use one of the templates from Microsoft, it is stored there.

There are good free alternatives available.

You can use the free calendar add-in from former Word MVP Greg Maxey that you can download from here: https://gregmaxey.com/wonrd_tip_pages/calendar_maker_addin.html This has several choices of formats.

You can also find free 2026 calendars on MVP Jay Freedman's download site. (https://jay-freedman.info/) These are simple macro-free templates.

You can find a free perpetual calendar maker add-in on MVP Graham Mayor's site. This allows a choice of background colors.

These templates are from trusted experts and have been used by thousands of users.

No one here can change how word works.

No one who can change Word sees what is written here.

This is a user-to-user forum. You are corresponding with your fellow users. We can tell you how to better use Word as it is.

People who can change Word never see what is posted here. To get their attention, use the Feedback mechanisms. Here is more information about how to do that and what to expect.

https://answers.microsoft.com/en-us/msoffice/forum/all/giving-feedback-on-microsoft-word-or-other/8df81a9b-84aa-46ef-bf88-24fb7fec96ba

Microsoft is not hearing about your problems from what you post here. You are discussing a problem with your fellow users here. We can give good advice about how to work with Word as it is and give suggestions for making it work properly.

Designers and their supervisors do see feedback. (You will almost certainly not get a direct response to that feedback but they do see it.)

I suggest using the Public Feedback Portal so other users can see your feedback, comment and vote. If you want, you can post the URL of your feedback with your question here to lead others with the same problem to your feedback. Be the “squeaky wheel” that gets fixed! https://feedbackportal.microsoft.com/feedback/forum/fb6d67e3-301c-ec11-b6e7-0022481f8472

Here is a link to some of the feedback on this issue:

https://feedbackportal.microsoft.com/feedback/search/fb6d67e3-301c-ec11-b6e7-0022481f8472?q=calendar

You can comment and vote if you want. I do not expect this to change, though. I recommend using the items from Jay Freedman, Greg Maxey, or Graham Mayor.

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2026-04-06T22:22:56.21+00:00

    Hi @Robert Bourgeois

    Good day, I hope you are doing well. 

    I have tested both Word and Excel calendar templates, however, I can only change the year using the Any year customer calendar template in Excel. For templates in Word, even it states that there will be a custom "calendar" tab on the ribbon to easily change the year, I was not able to find that tab in the ribbon. 

    User's image 

    According your concern, the best next step is to use the template in Microsoft Excel to be able to make changes in the calendar. To do this, please follow these steps: 

    1. In Excel, go to File > More templates. 
    2. Search "any year custom calendar" templates. 

    User's image  

    1. Select the first template. 
    2. Enter the year and select Start day of the week. 

    User's image 

    1. See the changes of each month in the corresponding tab. 

     

    I hope this information is helpful. Please follow the steps above and let me know if it works for you. If not, we can continue working together to resolve the issue.  

    Thank you for your patience and understanding. If you have any questions or need additional assistance, please don’t hesitate to reach out so I can continue to support you. If you found the response useful, please consider marking it as accepted, as this may help other community members who are looking for similar guidance.  

    I look forward to continuing the conversation.  


    If you have extra questions about this answer, please click "Comment". 

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.     

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.