I'm experimenting here so please bear with me or offer some direction/starter for ten.
We have SharePoint, Excel Online. I had an XLS on my desktop with a data connection out to CSV file to load a table, nothing to special but works a dream when the CSV was updated and the refresh done.
If I want to do something like this on SharePoint, so if I use XLS online a can not see anywhere under Data to create the Data Connection, what's missing?
Ideally I want the XLS online to be able to connect to a CSV elsewhere (on SharePoint or our Network) - what do I need to look into to make this work?