linking spreadsheets
 

I need to get information from a spreadsheet on a coworkers computer to a
spreadsheet on my computer. Is there a way to do this, so that when he
updates the data daily, it will also update it on my computer without me
having to manually enter the data? we cant put it on a shared drive and work
off the same spreadsheet, we both just need the same data to compute
different formulas, and since he updates it daily, its unproductive of me to
get the info from him and reenter it. Any help is greatly appreciated!!!