PDA

View Full Version : Solved: Making sheets of a shared workbook write-protected



rangudu_2008
12-23-2008, 10:27 AM
I've an excel workbook shared among various users. This workbook contains sheets for each user which they use. Is it possible to restrict write-access (disable editing) to other sheets apart from the sheet allotted/used by a user? In simple words, they should only be able to view the contents of the other sheets updated by others while should not be able to modify the contents. They should be able to use only the sheet allotted to them.

Only one power-user should be able to make changes to all sheets in the workbooks while all other users must have the type of access mentioned above.

Can this be implemented in Excel? I'm using Excel 2003.

Ranga

Jan Karel Pieterse
12-24-2008, 08:27 AM
I'd advise you to find a different way to do this, The shared workbook feature of Excel is badly implemented and frequently causes the files to become corrupt or contain wrong information.

You'd better use a single file per user and combine them later on. You can then put each file in its own network folder and assign proper rights to the folders, thus limiting what other users can do to the files.

Or alternatively, use an application like Access.