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-gantt-agile-tm55723235

 

excel
Formulas and Functions
office 365

4 Replies

    • 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