Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I created a list in SharePoint Online, I'm using the url to the list but I receive this error when trying to export from excel.
URL example: https://mysite.sharepoint.com/sites/mysite/lists/excel_test/allitems.aspx
I figured it out...
Excel creates the list for you. Add the URL to the SITE where you want to create a new list.
URL example: https://mysite.sharepoint.com/sites/mysite/
To update, you should have the ability to select from the existing list.
Required, but never shown