I have a workbook with a worksheet that pulls filtered data from a table on another worksheet all in the same workbook.
Everything works fine locally, but when I try to refresh the data in OneDrive or Sharepoint online, I get an "External Data Refresh Failed" error.
I don't know why this happens because I don't have any external data connections. In queries & connections no connections show, only my query.
Any ideas?
Bookmarks