Linking workbooks from Sharepoint

Hi all,

I'm trying to link data from two workbooks that are on our company's internal Sharepoint.

What function is required to link the sheets if they're both online? I understand that if I were linking two local spreadsheets, I could just use the paste link function, but that doesn't work here. Please help!!!

Also noteworthy is the face that I'm using Excel 2008 on a Mac. Not by choice, I assure you. I suspect this may be the complication, as I'm having a really difficult time referencing a "https://" site in the cell link. Anyone know a workaround?