allow user to edit excel
To publish a workbook to a document library on a SharePoint site, ensure that the site is available, and do the following: 1  Click the File tab, click Save & Send, and click Save to SharePoint. 2  In the Save As dialog box, choose a server location and the name of the workbook, and then click Save. Before you allow certain users to edit the range of cells, you should make sure that the workbook has not been protected. 1. Open the worksheet you want certain users to edit cells range, and click Review > Allow Users to Edit Ranges. 2. In the Allow Users to Edit Ranges dialog, click New button. I have a problem with Excel function Allow users to edit range, every time I try to set permission to any user Excel is crashing. More informations: 1. Computer is in domain. 2. It's happening on both Excel 2010 and Excel 2016 (o365 subscription). 3. Tested on Excel 2010/Windows 7, Excel 2016/Windows 10. Excel Desktop App. 1  1. Open the workbook and make any final changes to the design and structure of the workbook so that it's ready for use. 2  2. Select the Review tab and then click the Share Workbook command in the Changes section of the ribbon. 3  3. Check the box next to Allow Changes by More Than One User at the Same Time.. I have a problem with Excel function Allow users to edit range, every time I try to set permission to any user Excel is crashing. 1. Computer is in domain. 2. It's happening on both Excel 2010 and Excel 2016 (o365 subscription). 3. Tested on Excel 2010/Windows 7, Excel 2016/Windows 10. Allow certain users to edit cells range. Before you allow certain users to edit the range of cells, you should make sure that the workbook has not been protected. 1. Open the worksheet you want certain users to edit cells range, and click Review > Allow Users to Edit Ranges. See screenshot: 2. In the Allow Users to Edit Ranges dialog, click New button. Select the Review tab and then click the Share Workbook command in the Changes section of the ribbon. The Share Workbook dialog box opens. 3. Check the box next to Allow Changes by More Than One User at the Same Time.. 4. Click OK to save the settings. Excel prompts you to save the workbook. You can save Excel workbooks in different file formats so that those who do not have Excel can open them in other programs or data systems. You can save Excel files as XML files, text files, Web pages (HTML files), and others. For a list of formats that you can save to, see File formats that are supported in Excel. Collaborate by using a document management server when: 1  You have access to a document management server. 2  Users have Excel installed on their computers to open and use workbooks from the document management server. Excel normally doesn't allow multiple users to edit the same workbook, but you can get around this restriction using a shared workbook. Shared workbooks can be saved on your local network and accessed from Excel on the desktop, or they can be stored on Microsoft's SkyDrive, where users can edit in the Excel Web app.
1. Open the worksheet you want certain users to edit cells range, and click Review > Allow Users to Edit Ranges. 2. In the Allow Users to Edit Ranges dialog, click New button.