Update Project in P6 Database from an Excel Progress Sheet

1. 1

   Step 1

   Before you start: complete Open the Schedule Update Tool and Select a P6 Project.

   Choose Excel Sheets, then click the Browse button

   

2. 2

   Step 2

   Open the progress sheet path and open it

   

3. 3

   Step 3

   Select the new data date and time for the project, then click the Next button

   

4. 4

   Step 4

   This window shows the rules that the tool follows to update. If you do not want some rules to run, you can turn them off, then click the Run Verification button.

   

   

5. 5

   Step 5

   In this window, review the errors, warnings, and changes for the progress sheet. Set the working day if needed.

   

6. 6

   Step 6

   If there are errors, click the Errors button to fix them, or click Exclude all activities with errors. Then click the Next button.

   

7. 7

   Step 7

   Click the Update Project button

   

8. 8

   Next: Review in P6

   Follow Review and Schedule the Updated Project in P6 to refresh (F5) and schedule (F9) the updated project in P6.

← Back to all How-To guides