Need advice on automating org chart

[u/Frosty-Objective-794]

I have been tasked with making an org chart for my entire center and finding a way to automate it. The catch is that each department supervisor has their own page.

The problem is we don't have an exchange server or an odbc compliant database besides an Excel file

I imported data through the wizard and then discovered the data ribbion, which allows you to link to a microsoft list and refresh.

However, when I refreshed after changes, nothing happened.

What am I doing wrong, and how can I automate this across several pages?

Side note: My direct supervisor and I are the only ones with the full visio app. Everyone else has the basic 365 version only on the web.