Home > IT Answers > Microsoft Windows > User permissions in MS Excel
Windows Security ATE
160 pts.
 User permissions in MS Excel
Microsoft Excel, Network permissions, Windows Security
I have a question on sharing an MS Excel file. Is it possible to restrict a file so that each user can modify only his own tab within that file? Also, is it possible to, under the same of restrictions, have a group of admin users who can modify all the tabs?

Software/Hardware used:
ASKED: May 23, 2008  6:35 PM
UPDATED: May 25, 2008  3:14 AM
RELATED QUESTIONS
Answer Wiki:
Hi, You did not mentioned the version of Office you are using. In 2007 you can try from 'Review tab' under 'Changes' go to 'allow users to edit ranges' options. Good Luck
Last Wiki Answer Submitted:  May 24, 2008  12:08 am  by  ITCogent   115 pts.
All Answer Wiki Contributors:  ITCogent   115 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

By Tab I suspect you mean sheet and you can set protection on each sheet with a different password and only give the right password to the person who enters data on that sheet. But everyone can see all of the sheet.
My suggestion is use a different file for each person or group and a master that takes the data from all the rest to compile your final report.

If the number of people involved exceeds 10 you are better served by using MS-SQL for proper data access controls and forms. Any more then 10 people and protecting data, multiple user access. and even the volume of data will overwhelm the engine in excel.

Ysrd
 430 pts.