Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel File to a Network Drive | Excel Discussion (Misc queries) | |||
i cann't save my excel file on network it says sharing violation | New Users to Excel | |||
Sharing an Excel file NOT on a network? | Excel Discussion (Misc queries) | |||
Sharing file on a network | Excel Discussion (Misc queries) | |||
problem saving excel file on a network | Excel Discussion (Misc queries) |