Forum Discussion
Gantt chart error Excel 2016 Mac
Hello, I haven't had a lot of experience with Gantt charts so I'm struggling to find the cause as to why the chart isn't updating. Attached is the spreadsheet with the error I'm trying to s...
It looks like there are multiple named cells that sometimes have the same name as each other. So e.g. when I change cell D9 on the ProjectSchedule sheet, it changes the purple range on the Leadership Team sheet also, because the two CF rules both use the named range task_end and Excel is confused between them. Changing the names from the Name Manager and tidying up the rules should help.
