I am managing a Shared workbook and I am experiencing some of the pitfalls of the shared workbook.
I want to get some ideas how to proceed after I give the background.
1. The workbook is in the .xls format due to it being used in both 97-2003 and 2010 Excel Applications.
2. There are approximatly 17 end users that enter data into the workbook.
3. Each User has their own sheet so we do not have the conflict issues.
4. Today, we had the workbook dissapear from the network. (Luckily, I had a recently saved copy of it open)
I think my 2 options would be to either (a) get code to save a backup copy every x minutes to a different location on the network, (b) or give each user their own workbook and get code to merge the individual user workbook data with a master workbook that does all of the tracking. (right now all the master and individual tracking is done in the one workbook) I have daily, weekly monthly, etc tables to show work completed.
Thanks for your thoughts.
I want to get some ideas how to proceed after I give the background.
1. The workbook is in the .xls format due to it being used in both 97-2003 and 2010 Excel Applications.
2. There are approximatly 17 end users that enter data into the workbook.
3. Each User has their own sheet so we do not have the conflict issues.
4. Today, we had the workbook dissapear from the network. (Luckily, I had a recently saved copy of it open)
I think my 2 options would be to either (a) get code to save a backup copy every x minutes to a different location on the network, (b) or give each user their own workbook and get code to merge the individual user workbook data with a master workbook that does all of the tracking. (right now all the master and individual tracking is done in the one workbook) I have daily, weekly monthly, etc tables to show work completed.
Thanks for your thoughts.
