How do you connect to table in an excel 365 file saved in an SP document Library?
I easily connect to the table in my excel XLSM desktop app, but when saved in an SP document library, I can't connect to the same table. I can connect to it, and the list of available data connections appear, but where I saw "Table" in the excel desktop version, that same table doesn't appear when connecting through the Document Library.
I've tried this with an XLSX workbook and have had no luck with that format either.
My ultimate goal is to be able to connect a Powerbi app to this workbook.
Any help is appreciated.
