I am using office 365 and I have a few excel files sitting on OneDrive, I created an excel files and connected it to the other files on the OneDrive, When I work locally everything works fine and refreshes regularly.
However when I open the excel file in the web the connections won't refresh and I can't figure out why, Is this even a feature in Office 365? because I build something similar with Google Drive & Sheets.
Do I have to use a SQL server? or can excel online read data from OneDrive/Sharepoint?