Hmmmmmmmm, Are your users getting any messages when they open the workbook such as the file is open by another user and is locked for editing (or something similar to that)
I've ran into a problem something like this before and I know this sounds crazy but I could minimize the workbook and then maximize it and the problem would be gone. This was working across a server also.
Like this thread? Share it with others