+ Reply to Thread
Results 1 to 4 of 4

Any Year Calendar does not Update

  1. #1
    Forum Contributor
    Join Date
    04-20-2010
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2016
    Posts
    151

    Any Year Calendar does not Update

    I am using Excel 2016 for Any Year Calendar (see attached), but when I press the scroll buttons to change the Year number, the rest of the dates in months do not change.

    What might be the reason? I have tried other Any Year calendars, and have the same issue...
    Attached Files Attached Files
    Last edited by mrcois; 11-28-2015 at 04:36 PM.

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Any Year Calendar does not Update

    It's nothing wrong with your calender, it's fine, just check your formula calculation maybe it set to "manual", on formulas tab, and click on "Calculation Options" and choose "Automatic"

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Any Year Calendar does not Update

    mrcois, this thread is marked as solved, but it seems that is not the case?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,651

    Re: Any Year Calendar does not Update

    Change the calculation from manual into automatic
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calendar Year Update Macro Possibility
    By fearonc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2014, 06:05 PM
  2. Calendar Template Duplicating My Entries (Year On Year)
    By blarmey in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-10-2014, 03:14 AM
  3. Automatically update year interval cycles from year to year
    By trumptight in forum Word Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2014, 10:38 PM
  4. [SOLVED] Need help with Calendar formula for previous year and next year
    By dcoates in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 11:58 AM
  5. Transpose Quarters from Calendar Year to Fiscal Year
    By jodiander in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2013, 01:00 PM
  6. Input a year to determine the start date for 4-4-5 Calendar Year.
    By mak1176 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-25-2013, 10:34 AM
  7. [SOLVED] change the year in a calendar template to different year
    By George in forum Excel General
    Replies: 1
    Last Post: 07-19-2006, 02:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1