In addition to using integrated data, you can also use external Excel® data sources. To do so, click Excel Link.
A new window will now open where you can open data from either an Excel® file (local or on a network drive) or from an Excel® file from your SharePoint/OneDrive. Here you can select the desired area that you want to display in the Gantt chart.
A new window opens where you can open data either from an Excel® file (on-premises or on a network drive) or from an Excel® file from your SharePoint/OneDrive.
The easiest way is if you already have the Excel file open. Open files are always offered as the first option in the window.
After selecting a file, you can select the desired area that you want to display in the Gantt Chart.
You can then make further settings in the window for linking.
Here you can also select the option Automatically adjust Gantt period. When this setting is enabled, the Gantt chart period is automatically adjusted to the earliest and latest dates from the data range.