Jan 22 2021 07:34 AM
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?
Jan 22 2021 12:54 PM
SolutionNo, you may create Power Query connections only in desktop version.
Jan 22 2021 01:01 PM
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.
Jan 22 2021 12:54 PM
SolutionNo, you may create Power Query connections only in desktop version.