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.

Sharing Workbook Nighmare
 

Hi
don't think this is possible. They can make a copy of the sheet locally
but changes in this local copy are NOT reflected in the shared
workbook.

--
Regards
Frank Kabel
Frankfurt, Germany


TroyH wrote:
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.

Sharing Workbook Nighmare
 

Hi TroyH,

Have you considered a schema wherein the user would work
on a local copy of the worksheet he/she needed, and then
update the shared workbook via a Workbook_BeforeSave
trigger?

Something like this:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel As Boolean)
ThisWorkbook.Save 'Save the Local WB
'Update the Shared WB & Save It
'Your code to open the Shared WB
'Your code to transfer the current user
'entered data
'Your code to Save and Close the shared WB
ThisWorkbook.Saved = True
Cancel = True
End Sub

If the local copy of the single worksheet needs data from
the shared workbook, possibly it could be copied from the
shared workbook via a Workbook_Open trigger.

Depending on size and complexity, you may see some speed
enhancement except in the saving process.

Best Regards,
Walt


-----Original Message-----
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.
.