Refreshing data source in excel online

%3CLINGO-SUB%20id%3D%22lingo-sub-1630641%22%20slang%3D%22en-US%22%3ERefreshing%20data%20source%20in%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1630641%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BI%20am%20using%20office%20365%20and%20I%20have%20a%20few%20excel%20files%20sitting%20on%20OneDrive%2C%20I%20created%20an%20excel%20files%20and%20connected%20it%20to%20the%20other%20files%20on%20the%20OneDrive%2C%20When%20I%20work%20locally%20everything%20works%20fine%20and%20refreshes%20regularly.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20when%20I%20open%20the%20excel%20file%20in%20the%20web%20the%20connections%20won't%20refresh%20and%20I%20can't%20figure%20out%20why%2C%20Is%20this%20even%20a%20feature%20in%20Office%20365%3F%20because%20I%20build%20something%20similar%20with%20Google%20Drive%20%26amp%3B%20Sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20I%20have%20to%20use%20a%20SQL%20server%3F%20or%20can%20excel%20online%20read%20data%20from%20OneDrive%2FSharepoint%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help%20in%20advance%2C%3C%2FP%3E%3CP%3EMichael%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1630641%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hello all, 

 

 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? 

Thanks for the help in advance,

Michael 

0 Replies