Sharing Workbook Nighmare
I am creating a workbook that will reside on a network drive. There will be approx. 15 different users accessing this workbook. Here is my delima
The workbook does this
Users will be creating multiple pages which will be copied and deleted from shared workbook when they close
Users will have the ability to add certain data to only 1 sheet of the shared workbook
I have a few users who are very paranoid and want the abilty to save the workbook locally in case of a power outtage, etc
How do I stick with a single shared notebook but allow users the option of saving locally and keeping the data on the one single sheet active
Thanks.
|