Sync your timeline with MS Project

Follow

Overview

If you have a timeline imported from MS Project, that timeline remains linked to the original .mpp file. This way, you can update it effortlessly when the Project data changes using Office Timeline’s Sync wizard. This guide will show you exactly how syncing with Project works.

You’ll read about: 

A) Getting started
B) Filtering what you see in the Sync data list
C) Selecting the items to sync and what happens depending on status

 

Read the whole guide or use the links above to jump to the section you’re interested in.

 

A) Getting started 

 

To get started synchronizing your timeline with Project, first click the Sync button on the Office Timeline ribbon in PowerPoint.
sync-button-office-timeline-ribbon.png

The Office Timeline add-in will connect to your linked Project file and open the Sync wizard, where all the magic happens.
sync-wizard-project-sync-office-timeline.png

Quick tip: If you wish to sync your timeline with another .mpp file than the one already linked, click on “Change file” next to your file’s name in the upper right corner of the Sync window.
change-file-to-sync-with-project-office-timeline.png

 

B) Use filters to view what's relevant to you

 

In the Sync window, you will see a list of all data that’s different in Project compared to your current timeline, as well as a Status for each item, so you can get a clear overview of the updates.

list-of-changed-data-project-sync.png

You can filter by status what you see in the data list by clicking the little dropdown arrow on the “Status” column. filter-rows-by-status.png

These filters will affect only your current view, they have no impact on the final timeline. Only the rows you select (or deselect) from the data list will impact the visual.

 

C) Selecting the items to sync and what happens to them depending on status

 

After you’ve set up your filters to see exactly what you need in the sync list, you can easily select the items to accept for syncing by checking the boxes in the leftmost column:select-rows-to-sync-project-import-office-timeline.png

To move even faster, you can use the checkboxes above the data list to select or deselect whole groups of items depending on their status.

group-selection-sync-with-project-office-timeline.png

But speaking of statuses, let’s see what each of them means and what happens to the different types of rows when syncing:

 

Overview of statuses

Changed 
changed.png
One or more of an item’s values (title, start date, end date etc.) differ in Project compared to your current timeline. We’ll show you both the timeline version and the Project version of said item (task/milestone), with the differences highlighted, so you can easily decide which version to keep.

  • Select a Changed item to bring its Project version into your timeline when syncing.
  • Deselect it to keep the values you currently have on your visual.

Deleted
deleted.png
The task/milestone exists on your current timeline but was deleted from the Project file.

  • Select a Deleted item to remove it from your timeline.
  • Deselect it to ignore the deletion and keep the task/milestone on your timeline.

New
new.png
The item didn’t exist in Project the last time you imported (or synced with) the .mpp file.

  • Select a New task or milestone to add it to your timeline. 
  • Deselect it to ignore it when syncing.

Imported
imported.png 
The item is already on your timeline and hasn’t suffered any changes since you last imported it.

  • Select an Imported item to keep it on the timeline.
  • Deselect it to remove it.

Not Imported
not-imported.png
The item existed in the Project file the last time you imported or synced with it, but you didn’t bring it into the timeline.

  • Select a Not Imported item to add it to the timeline. 
  • Deselect it to ignore when syncing.

Invalid
invalid.png
The item is not importable (e.g. the title or start & end dates may be missing). To “fix” invalid items, go back to you Project file and double-check the task names and dates.

 

Once you’re done choosing the items to sync, click the green Finish button in the bottom right corner, and that’s it - your timeline will instantly be updated.

finish-syncing-with-project-office-timeline.png

 

Notes:

  • You can use the Sync settings menu in the upper-right corner to choose whether you want to import 1-day tasks as milestones or to ignore title changes when syncing.
    sync-settings-office-timeline-add-in-project-sync.png
  • Syncing goes one way only. It will update your PowerPoint slide to match the changes in your MS Project file. Office Timeline will not impact or change your original .mpp file in any way.

 

Have more questions? Submit a request

Comments