We access an Excel 2002 file on a network. Multiple
people access the file but only one needs to update the
information. We get the read only signal when the file is
already open and can not save updates to the file until
the 1st user is out of the file. This can take all day if
they leave the file open.

Suggestions?

I am thinking of writing an Auto_Open Macro that makes a
copy of the file for the general user and closes the
original immediately. Then have a macro that saves the
file back to the original position for the one person or
do it by hand.

Ken