Sharepoint and Excel Services - Restrict Access by Tab -


I was wondering if there should be an Excel workbook on SP1 and it should be done so that different people can be enabled Edit different tabs in the workbook - but there are no other tabs? I am very new to Sharepoint and am trying to get up to speed, but in my quest I have not found any way to do it yet. I'm not sure that this is also possible. This will help our work to keep a spreadsheet, where different people edit different tabs and we have a central administrator on the whole document.

Any help is appreciated - Thanks and a great day!

I think you use Excel Web Access Web Part in SharePoint to provide access to the workbook.

First of all, the purpose of the Excel Web Access Web Part is to provide a reading-only view of the spreadsheet. Users can edit data using the "Open in Excel" button, which will surely provide access to all tabs (worksheets), there is no way to set different access groups for each worksheet tab in Excel, And SharePoint is simply published Excel workbook surfacing.

You can use different Excel Web Access Web Parts to display different worksheet tabs based on name items that you define in the workbook. These web parts are then used by the Audience utility, each user group Can be filtered for.

If you only want the selected users to have the ability to view data in other worksheets, you will want to edit the toolbar menu for the Web Part, otherwise download all the excel documents from all user web documents and to all worksheets. You can see it anyway.

Of course, the user will also be able to browse in the document library that stores the workbook and downloads a copy from there, so it is important to protect sensitive worksheets, so the best option is to use Excel password Have to protect some worksheets for privileged user groups


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -