need to connect to excel stored on sharepoint 365
I need to be able to open an excel file stored on sharepoint that is part of office 365. Our spotfire version is 7.11. I can go to the sharepoint and get the URL for the excel and it looks like a valid URL (http://sharepoint.........) - I then stripped of whatever was after ".....xlsx?" and then tried that link on File-Open - it works fine and I can read it in and create the visualizations. But if I save that file and pass it on to another team member, they get file open error - my suspicion is that it downloads the excel and uses a local cached link and this doesn't work for someone else. I am aware of OData conenction but not sure how to use it - it talks about creating a listsvc URL and try it on the IE but I don't know how to construct such a link from the excel file link. Any help is appreciated.