Sharing Excel File on Network - Saving
 

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

Sharing Excel File on Network - Saving
 

Can't you set the protection options for the file so it is read-only recommended? That should prevent most users from opening it read/write. Alternately, the one user who needs write access could open the file and never close it (grin).