SOLVED

Connecting Excel Online to a SharePoint list?

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.