excel 2007 opening files on network share
 

I'm opening files on a network share and the most recent changes made by me
on another computer are not showing up. They will show up if I navigate out
to the network share and right-click the .xls file and tell it to
synchronize, and then open it.

I don't want to have to manually synchronize every time I open the file.

Anyone have any ideas?