I was poking around in Visio yesterday, working in a Gantt chart and came across an option to have the data "source" Excel spreadsheet be visible on the bottom of the Gantt Chart. Visually, I was able to see the Gantt on the top and the Excel spreadsheet tasks below. I then used the Link option in Visio and was able to link the two applications. When I updated the Excel spreadsheet, it would also update the Gantt.
For the life of me I cannot recreate this.
Does anyone know how to recreate this scenario?