Using Excel 2013 it was possible to import the list(s) data from SharePoint online into excel using OData option. This excel when uploaded to SharePoint document library, It was possible to perform the real-time refresh of the data so that the excel pulls the information directly from the SharePoint list into the excel online(not from excel on local machine).
Based on my experiments i have written couple of Blogs here :
However, in Excel 2016 it doesn't seem to work. I get the error when i try to refresh. This was a good feature to be used by people who are happy with mini custom application driven through SharePoint.
Can anyone tell why this is not working now? and how to report this ?