prevent the over-write

  • Thread starter Thread starter flex-drop
  • Start date Start date
F

flex-drop

I have a public workbook that is updated by other users. One of the
worksheets is being deleted. I have protected the worksheet but that didn’t
solve the problem. I believe someone is coping the workbook to a local drive
or some other location, deleting the worksheet and then overwriting the
original workbook. I can prevent the file from being deleted with special
permissions but I can’t prevent the over-write. Is there a way to protect
the structure of the workbook and keep it public?
 
flex-drop said:
I have a public workbook that is updated by other users. One of the
worksheets is being deleted. I have protected the worksheet but that
didn’t solve the problem. I believe someone is coping the workbook
to a local drive or some other location, deleting the worksheet and
then overwriting the original workbook. I can prevent the file from
being deleted with special permissions but I can’t prevent the
over-write. Is there a way to protect the structure of the workbook
and keep it public?
Click to expand...

That is more a function of the OS environment you are using, whether it
is MS or Novell. Your administrator can set the permissions on the
file or folder based on groups. One group can delete, edit, update or
replace. Another gorup can only view. Talk to your Admin.



--
 
Chris thanks for the input.

I failed to you use the phrase “idiot proofâ€. Meaning, the file is being
over-written by someone with permission to write to the file.

So although the network administrators, in our case Novell, could apply some
type of properties to this file, they’re not going to do it for one file. I
could assign special properties to individuals but I will still have the
‘unknown idiot’ working on the workbook (they are probably not aware of what
they’re doing.)

This forum has many references to various permissions and security options
for worksheets and cells. I have attempted to setup a combination of these
Excel properties but I haven’t been able to crack the code, I always end up
with too much locked. I’m hoping someone can share a common experience that
has a solution. I don’t have a lot of experience at this level and I
mistakenly thought it would be easy.
 
flex-drop said:
Chris thanks for the input.

I failed to you use the phrase “idiot proofâ€. Meaning, the file
is being over-written by someone with permission to write to the file.

So although the network administrators, in our case Novell, could
apply some type of properties to this file, they’re not going to do
it for one file. I could assign special properties to individuals
but I will still have the ‘unknown idiot’ working on the workbook
(they are probably not aware of what they’re doing.)

This forum has many references to various permissions and security
options for worksheets and cells. I have attempted to setup a
combination of these Excel properties but I haven’t been able to
crack the code, I always end up with too much locked. I’m hoping
someone can share a common experience that has a solution. I don’t
have a lot of experience at this level and I mistakenly thought it
would be easy.
Click to expand...

The only other option I can think of is to create a different workbook
for each individual that you need data from and then link to those
workbooks from the master. That way the master is pulling the data and
those individuals that need to update various parts are only affecting
their workbooks.

Would that work???

--
 
flex-drop said:
Chris thanks for the input.

I failed to you use the phrase “idiot proofâ€. Meaning, the file
is being over-written by someone with permission to write to the file.

So although the network administrators, in our case Novell, could
apply some type of properties to this file, they’re not going to do
it for one file. I could assign special properties to individuals
but I will still have the ‘unknown idiot’ working on the workbook
(they are probably not aware of what they’re doing.)

This forum has many references to various permissions and security
options for worksheets and cells. I have attempted to setup a
combination of these Excel properties but I haven’t been able to
crack the code, I always end up with too much locked. I’m hoping
someone can share a common experience that has a solution. I don’t
have a lot of experience at this level and I mistakenly thought it
would be easy.
Click to expand...

The only other option I can think of is to create a different workbook
for each individual that you need data from and then link to those
workbooks from the master. That way the master is pulling the data and
those individuals that need to update various parts are only affecting
their workbooks.

Would that work???

--
 
Chris Premo said:
The only other option I can think of is to create a different workbook
for each individual that you need data from and then link to those
workbooks from the master. That way the master is pulling the data and
those individuals that need to update various parts are only affecting
their workbooks.

Would that work???
Click to expand...
 
Back
Top