Restricted access to the sheets

  • Thread starter Thread starter Ivan
  • Start date Start date
I

Ivan

Hello,

I'm using Excel 2007 and I have a task to make an excel dokument where
different user of my company will have access only to their own sheets not
but to the sheets of their colleague. Is there a way to accomplish this
duty?

Ivan
 
Ivan said:
Hello,

I'm using Excel 2007 and I have a task to make an excel dokument where
different user of my company will have access only to their own sheets not
but to the sheets of their colleague. Is there a way to accomplish this
duty?

Ivan
Click to expand...

There are various ways to hide information in a worksheet. They are not all
practical and will not deter the determined or adventurous. Indeed even
password protection can be cracked in minutes.

Change text AND background colour to, say, white.

Click on <Format><Sheet><Hide>

Reduce all columns width and rows height to 1.

Why not all three (and any others that come to mind)? That'll keep them
guessing for a while!

Always keep a backup so that, if anyone broke in and changed information, by
accident or intent, you can restore the situation very easily. It is good
to trust colleagues but it is also good to be aware that they may not all be
trustworthy.

Regards.

Bill Ridgeway
Computer Solutions
 
If the information is private and shouldn't be shared with others, then don't
put it into excel.

You may be able to come up with some routine that hides/shows worksheets that
you want, but this can be broken easily and anyone who's interested will be able
to see all the other data.

Excel's security isn't made for this kind of thing.
 
For every sale project we have one excel file (workbook) and it is shared on
a server. More user shoud put data into the forms in their worksheet of that
workbook. These user should not have access to the data from the other
sheets, the data is but through worhsheet functions connected and sumarized
in the special final worksheet.

We find excel as the best tool for the performing of the calculations on the
base of many different parameters. All other tools are to much rigid. But
with excel there remain only the question of the security - how to prevent
to some users the access to some risk data if these users on the other hand
must collaborate on some parts of the project.

Ivan
 
Excel is not a secure product and cannot be made secure. Even password
protection is not secure.

The only suggestion I can make to you is that you have one 'super' user who
can be trusted with the business information and for that person to send to
other users information which they need for their particular function and to
receive back data to update the master spreadsheet. This may not be
particularly practical but is as secure as may be. Practicality, after all,
is a compromise of security. You need to assess the importance of
practicality and security and come to a happy medium.

Regards.

Bill Ridgeway
Computer Solutions
 
Create a folder for each salesperson and secure those folders so that only
that salesperson and the supervisor(s) can access it. Each salesperson will
have his own workbook located in his (or her) own secured folder.

Give the Supervisor(s) a workbook which aggregates the data in from those
workbooks by referencing them. (=path\filename.xls etc.)

Since the salesperson only has access to their own folder they can't access
anybody else's data. Since the Supervisor(s) have access to all of the
folders they can access all of the data.

I'm not convinced Excel is really the best tool for this if security is such
a high requirement but that should work.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com/excel.htm
 
Back
Top