I am not trying to link to Epicor - this is a straight Excel question.
I want to link a CSV file to Excel as a data connection only. The CSV file is 200MB and about 1.2 million rows, so it can’t be actually in Excel. It works fine on my desktop.
But now I put the two files (Excel and CSV) on OneDrive. (I could put it in SharePoint if it helps; I think it’s basically the same idea, right?)
I made a shareable link to the file. But if I try to use that as the data source in Excel, it gives an error.
- If I use the wizard it says “You can’t open this location using this program…”
- If I try to edit it in PowerQuery, it says “Access to the resource is forbidden.”