SOLVED

Connecting Excel Online to a SharePoint list?

%3CLINGO-SUB%20id%3D%22lingo-sub-2087167%22%20slang%3D%22en-US%22%3EConnecting%20Excel%20Online%20to%20a%20SharePoint%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2087167%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20how%20to%20connect%20regular%20Excel%20to%20a%20SP%20list%20but%20is%20it%20possible%20to%20do%20it%20using%20Excel%20Online%3F%26nbsp%3B%20In%20the%20Data%20section%20of%20Excel%20Online%2C%20I%20don't%20see%20a%20create%20connection%20type%20setting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2087167%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2088434%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20Excel%20Online%20to%20a%20SharePoint%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2088434%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325149%22%20target%3D%22_blank%22%3E%40Bryan123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%2C%20you%20may%20create%20Power%20Query%20connections%20only%20in%20desktop%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2088453%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20Excel%20Online%20to%20a%20SharePoint%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2088453%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20afraid%20so.%26nbsp%3B%20Oh%20well%2C%20I'll%20just%20manually%20paste%20data%20into%20a%20%22data%22%20sheet%20in%20Excel%20Web%20when%20I%20need%20to%20update%20it.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I know how to connect regular Excel to a SP list but is it possible to do it using Excel Online?  In the Data section of Excel Online, I don't see a create connection type setting.

 

Is this possible?

2 Replies
best response confirmed by Bryan123 (Contributor)
Solution

@Bryan123 

No, you may create Power Query connections only in desktop version.

@Sergei Baklan 

 

I was afraid so.  Oh well, I'll just manually paste data into a "data" sheet in Excel Web when I need to update it.