Gantt Excel is all about speed. A million calculations need to take place in literally less than a second to create the beautiful timeline that you see.


If the calculations in your gantt worksheet has slowed down here are a few things to watch out for.


  1. Do you have other excel worksheets with formulas open?
    This can slow down the Gantt template. Please close all other excel files especially if you have a lot of formulas in them.

  2. Do you have a lot of memory intensive programs open on your computer?
    You may have to close them as Microsoft Excel may not enough memory for it to work correctly

  3. Do you have a single parent task with hundreds of child tasks under it?
    We do not recommend this structure as any change within the child tasks will trigger date, cost and timeline calculations for all child tasks, sub parent tasks and parent tasks.

  4. Do you have a lot of task dependencies in your program? Are all tasks dependent on each other?
    Well in this case any change within the dependent tasks will trigger date, cost and timeline calculations for all tasks, sub parent tasks and parent tasks. This does take time (should take less than 2 seconds for 200-300 tasks)


As an example, here is a small sample of calculations that happen when you add a task.


  1. Check if the worksheet is a gantt worksheet
  2. Unprotect required parts of the worksheet
  3. Add today's date for Estimated start date
  4. Add default duration as 1 day
  5. Scan all holidays and add them to memory to calculate end date
  6. Scan workdays in a week and add them to memory to calculate end date
  7. Calculate estimated end date based on start date, duration, holidays and workdays
  8. Scan resources so that they can be selected
  9. Trigger Resource cost calculation based on duration
  10. Set and save baseline dates and calculate based on items 2-6
  11. Set and save actual dates and calculate based on items 2-6
  12. Check date format in settings and format all date fields
  13. Save estimated, baseline and actual costs
  14. Check currency in settings and format all cost fields
  15. Scan all tasks that can be set as predecessor tasks and save them to the tasks dependencies dropdown
  16. Save all predecessor tasks that user has selected with type of task dependency and lag
  17. Recalculate estimated start and end date based on task dependency information
  18. Save estimated, baseline and actual color data into the task row
  19. Check if Percentage calculations are set to Automatic in settings
    1. If yes then calculate task percent value based on start date, end date and current date
    2. If not save manually entered value
  20. Save notes to task row
  21. Check the current view (daily, weekly etc...) 
  22. Calculate Timeline start date based on earliest task start date
  23. Calculate and set timeline columns based on number of time columns to be drawn set in settings.
  24. Check if task estimated and end dates are available in the timeline
  25. Calculate estimated timeline bar start position based on start date in the timeline
  26. Calculate estimated timeline bar end position based on end date in the timeline
  27. Draw estimated timeline bar based on color set by user
  28. Check if baseline bar needs to be drawn
    1. If yes then
    2. Calculate baseline timeline bar start position based on start date in the timeline
    3. Calculate baseline timeline bar end position based on end date in the timeline

    4. Draw baseline timeline bar based on color set by user

  29. Check if percent complete bar needs to be drawn

    1. If yes then

    2. Calculate start point based on start date of task

    3. Calculate end point based on start date, end date and task percent complete value

    4. Draw percent complete bar based on color set by user

  30. Check if actual bar needs to be drawn

    1. If yes then

    2. Calculate actual timeline bar start position based on start date in the timeline

    3. Calculate actual timeline bar end position based on end date in the timeline

    4. Draw actual timeline bar based on color set by user

  31. Check if overdue bar needs to be drawn

    1. If yes then

    2. Calculate if task is overdue based on start date, end date, duration, task percentage complete and today's date

    3. Calculate and draw overdue bar based on color set by user

  32. Calculate today's date and find today column in timeline

  33. Draw Today column bars based on color set by user

  34. Draw borders for newly added task based on color set by user

  35. Move other tasks if task was added in between tasks

  36. Add line 'Type here to add new task' at the bottom of all tasks

  37. If task is a child task then recalculate all dates (baseline, estimated and actual), all costs (baseline, estimated and actual), task percent for

    1. All sub parent tasks

    2. All parent tasks

    3. Check if all dates, costs and task percent is valid for all child tasks

    4. Redraw all timeline bars for all parent tasks

    5. Redraw all timeline bars for all sub-parent tasks

  38. If task is a dependent task then recalculate all dates (baseline, estimated and actual), all costs (baseline, estimated and actual), task percent for

    1. All sub parent tasks

    2. All parent tasks

    3. Check if all dates, costs and task percent is valid for all predecessor and successor tasks

    4. Redraw all timeline bars for all parent tasks

    5. Redraw all timeline bars for all sub-parent tasks

    6. Calculate start and end points for all dependency task arrows

    7. Draw dependency arrows based on color set by user


Again this is just a tiny subset of the things that happen when a single task is added. We often stop all work and sometimes marvel at how extremely powerful excel is. 

It is truly an amazing piece of software and definitely the best amazing spreadsheet program ever made.


So if your Gantt chart has slowed down and if you need us to take a look at it please raise a ticket and send us your file. We'll be happy to check it for you.