Project Planner (Advanced) Excel Template – Expanding Number of Projects/Tasks

Posted on

This post is a tutorial on how to increase the number of projects and tasks that the Project Planner (Advanced) Excel Template – v2 can handle.

To increase the number of tasks, please do the following.

  • Unhide a sheet named Scheduler

 

Project Planner (Advanced) Excel Template - Unhiding Scheduler

Project Planner (Advanced) Excel Template – Unhiding Scheduler

 

  • Go to cell OC253. You can do this easily by pressing Ctrl+G and typing OC253 in the window.
    Project Planner (Advanced) Excel Template - Go To Cell OC253
    Project Planner (Advanced) Excel Template – Go To Cell OC253

     

  • Click the little arrow at bottom right of the cell and expand down to include more rows. You have now expanded the number of tasks.
    Project Planner (Advanced) Excel Template - End of Scheduler
    Project Planner (Advanced) Excel Template – End of Scheduler

     

ExtendingRows

Please be aware that as you increase the number of tasks, Excel needs to make hundreds of thousands of extra calculations. So, please add a few tasks at a time to see how Excel responds.

Let’s assume we increased by 10 rows (tasks).

  • Unhide H_RES sheet;
    • Select cells A252 and A253. Drag down to A273. This will add numbers 254 to 263.
    • Select B253 to NE253; Drag the formulas down to 10 more rows.
  • Unhide H_BP sheet;
    • Select cells C253 to NE253; Drag the formulas down to 10 more rows.

 

To increase the number of projects in Summary view

  • Go to PLAN SUMMARY sheet and click on the REVIEW ribbon and choose ‘Unprotect Sheet’.

 

Project Planner (Advanced) Excel Template - Unprotecting Sheet
Project Planner (Advanced) Excel Template – Unprotecting Sheet

 

  • Enter Password (provided in the SETTINGS sheet). You can now make changes to the sheet.
Project Planner (Advanced) Excel Template - Unprotecting Sheet
Project Planner (Advanced) Excel Template – Unprotecting Sheet

 

  • Go to cell P55 and extend the table as shown below.

 

Project Planner (Advanced) Excel Template - Expanding Projects
Project Planner (Advanced) Excel Template – Expanding Projects

 

To increase the number of projects in the timeline view

 

  • Select cells R55 to BT55.
  • Drag the mouse down to copy the cells (as many rows as you did earlier)
  • Press Ctrl+1 to open the formatting dialog box.
  • Click on the centre horizontal line border. This would remove the unnecessary border lines.

 

  • Project Planner (Advanced) Excel Template - Extending Tasks - Timeline view
    Project Planner (Advanced) Excel Template – Extending Tasks – Timeline view

     

8 thoughts on “Project Planner (Advanced) Excel Template – Expanding Number of Projects/Tasks

  1. Hi , I’m interested in buying the advanced project manager but I would like to know the maximum of projects (not tasks) that can be put in.
    Kind regards,

    1. Thanks for your interest.
      The default limit for projects is 50. It can be expanded as explained in the article above. However, the speed of the file will slowly reduce as more and more projects are added.
      Please let us know if there are any questions.
      Thanks & Best wishes.

  2. Hi Indzara,

    I am looking for team resource planner for customer auditing visits.

    Summary:
    I need to.plan visits for team members, at customer sites. Normally nearest team members need to travel to customer location to save transport cost.
    To complete audit I have start date and end date and to decide how many members need to travel to complete audit have a method based on internal calculations.

    Do you have something based on closest distance of auditor to customer location planner?

    1. Thanks for your interest.

      I am sorry that I don’t have any template related to closest distance calculator.

      Best wishes,

  3. How would I be able to view more than 50 task at a time on the “TASK SCHEDULES” sheet?

    1. Please unlock the sheet using the password provided. Then, unhide columns A and B. Select cells in last row (63) and then drag down to fill the formula down to row 64. This will show the schedule for 51st task. You can extend further down for more rows as needed. Please let me know if there are questions. Thanks. Best wishes.

      1. Do you have any additional suggested instructions to achieve this.
        I have done what you have suggested and copied the formula down. I also had to copy the formats which appears to look the same in the new rows.
        Is this correct or should I have done it another way as the top information above the table isn’t all agreeing.
        All tasks from all projects are now displayed.
        #TASKS are correct
        Still states Tasks 1 to 50 out of…
        I have experimented with the page break and print area settings but have had no success.

        1. Thanks.

          Can you please clarify? all tasks are displayed or stops with 50? Please email file to contact@indzara.com if possible.

          Thanks & Best wishes.

Leave a Reply

Your email address will not be published. Required fields are marked *