Seems to be the case for all our spreadsheets on the network share. I have
tested this with several and the result is always the same. I can open any
excel file that someone else already has open without any error/warning. It
is a mixed 2003/2007 environement.

Google has failed me, any suggestions on how to resolve?