Forum Discussion

MEDuguay's avatar
MEDuguay
Copper Contributor
Jan 06, 2020

Excel Template

Hi! i have downloaded this template and their is some element that doesn't work anymore. How can I get support to have my board works perfectly? https://templates.office.com/fr-fr/diagramme-de-gant...
excel
Formulas and Functions
office 365
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 07, 2020

MEDuguay 

Would be helpful if you could indicate which element doesn't work.

  • MEDuguay's avatar
    MEDuguay
    Copper Contributor
    Jan 07, 2020

    Hi Riny_van_Eekelen ,

    Great question.

    It's the category: goal and milestone. When I insert a new row for a new task, these 2 categories doesn't appear in the calendar lines. It's like if the formula, to get the yellow flag and the red ''flower'' can not be duplicate... 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jan 07, 2020

      MEDuguay 

      Downloaded the template (French version) from the link you inserted. Saved it as an xlsx file and studied the schedule. The date in F3 is set at the earliest date that exists in the named range "Jalons" and it determines the calendar view in columns I:BL. Towards the bottom, there are two dates from July 2018. Hence, the calendar displays entries from July 2018 onwards. Deleted these two tasks and the calendar starts in January 2020. I suspect that this will resolve your problem.

Resources