Hello I use Excel for Mac: Version 16.24 Yesterday all my Excel workbooks will not open without hitting 'Grant Access'. When doing that, I get an 'Alert' telling me that either the file format or file extension is not valid and the workbook will not open. This affects ALL of my Excel workbooks. Well, the process is still not over, we need to do one more simple step i.e. Go to Central Administration - Manage services on server (under System Settings) and start ‘Excel Calculation Services’. Grant Database Access. We need to grant database access to our Excel Service Application Pool. Open ‘MS SQL Server Management Studio’. Enter the name of the user or group to whom you want to grant permission and then click OK. If you’re not sure of the name, click the Advanced button. This action brings up a dialog box from which you can search for existing users. When you click OK, you return to.
Many Mac computers in my company suddenly started to experience intermittent 'Grant Access' dialogs upon saving Excel files on desktop. The timing for all of these computers seems more than a coincidence. In conjunction with this timing, some users have various problems saving (causing Excel to free.
1. On the Review tab. in the Changes group,click Allow Users to Edit Ranges:
Note: This command is available only when the spreadsheet is not protected.
2. Do one of the following:
- To modify an existing editable range, select it in the Ranges unlocked by a password when sheetis protected box, and then click Modify.
- To delete an editable range, select it in the Ranges unlocked by a password when sheet isprotected box, and then click Delete.
- To add a new editable range, follow next steps:
1. Click New to open dialog box:
2. In the Title box, type the name for therange that you want to unlock.
3. In the Refers to cells box, type anequal sign (=), and then type the reference of the range that you want to unlock. You can also click theCollapse Dialog button, select the range in the spreadsheet, and then click the CollapseDialog button again to return to the dialog box.
4. In the Range password box, type apassword that allows access to the range. The password is optional. If you don't supply a password, thenany user can edit the cells.
5. Click Permissions to open dialog box:
6. Add users that you want to be able to edit theranges or remove them, and then click OK three times.
3. After all changes, in the Allow Users to EditRanges dialog box, click the Protect Sheet... button to open the Protect Sheetdialog box:
4. In the Allow all users of this worksheet to list,select the elements that you want users to be able to change (see Protect Excel spreadsheetoptions).
Grant Access Excel Mac
5. In the Password to unprotect sheet box, type apassword for the sheet, click OK, and then retype the password to confirm it.
Note: The password is optional. If you don't supply a password, then any user canunprotect the sheet and change the protected elements. Make sure that you choose a password that is easyto remember, because if you lose the password, you cannot gain access to the protected elements on the spreadsheet.
Microsoft Access Vs Excel
See also this tip in French:Comment autoriser des utilisateurs spécifiques à modifier des plages dans une feuille de calcul protégée.