I'm trying to link a data file to an Excel file stored on SharePoint 365. In the past (for SharePoint 2010), I was able to put in the URL of the file, put in my authentication information, and pull the fill into Omniscope. Does anyone know how to pull or push files to SharePoint 365? Is there a different setup needed to the address or authentication? I even tried different port #'s. I can map the SharePoint on my network drive to my computer and pull it over that way, but I'd like to put in the URL to pull or push a file to SharePoint 365. Anyone else had any luck doing this?

Thanks!!