You can easily select the updates to make to your timeline by checking the boxes in the leftmost column of your data table: Only the rows you select (or deselect) from the data list will actually impact the visual.Ĭ) Selecting the items to refresh and what happens to them depending on status Note that both types of filters (Status and Custom) will affect only your current view – they’ll have no impact on the final timeline. To do so, click on the Filter button located on the top-right of the data list, and then add your desired conditions in the window that pops up. You can also create custom filters to refine your view even further. Simply click the arrow on the “Status” column header and check or uncheck whatever you wish from the dropdown menu. You can use the Status filters to show or hide from view all items with a specific status. If you’d like to customize what you see in the data list, there are 2 ways you can filter your view: Quick tip: If you wish to use another Excel file other than the one already linked to your timeline, click on “ Change file” next to your file’s name in the header of the Refresh window.īy default, in the Refresh window, you will see a list of all the data that’s different in the Excel sheet compared to your current timeline, as well as a Status for each item, so you can get a clear overview of the updates.
The add-in will connect to the source Excel file and open the Refresh Data wizard: To start updating your imported timeline, click the Refresh Data button on the Office Timeline tab in PowerPoint.
#Office timeline excel full#
Read the full guide or use the links above to scroll straight to the chapter you’re interested in. Here we’ll show you exactly how it works.ī) Filtering your view in the Refresh Data listĬ) Selecting the items to refresh and what happens depending on status
#Office timeline excel update#
This way, you can update your visual effortlessly whenever your Excel data changes, by using Office Timeline’s Refresh Data feature. When you import data from Excel into our PowerPoint add-in, the resulting timeline remains linked to the original Excel file used (the source file).