|So are you saying that the file can only be opened when you are sitting at the machine where the file resides?|
Is it really a server as in a file server or is it somebody's desktop where one of the folders is shared?
Is the workbook itself shared or just the folder?
Could the permissions on the file have changed such that only those that are logged into the machine where the file resides can open it?
Have you tried copying the contents of the file into a new file and tried to access that one over the network?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.