Grant access to excel file downloaded from email

The second way-out is useful only when connection has to be made to access the data of Access in Excel. The third suggested process is to export Access data items into Excel spreadsheet. Certainly, this is the best practice when the data exchange is periodical in nature. Below are explained few, common cases that require exporting data from Access i. This question actually means as how to export data into an Excel spreadsheet from MS Access database i.

The reason being, that Access database is saved in. You have two choices here:. File encryption : When you choose this option, you specify a password and lock the Excel file. This prevents other users from opening the file. For more information, see Protect an Excel file. Setting a password to open or modify a file : You specify a password to open or modify a file. Use this option when you need to give Read-only or edit access to different users. Mark as Final : Use this option if you want to mark your Excel file as the final version and want to prevent any further changes by other users.

For more information, see Add or remove protection in your document, workbook, or presentation. Digital signature : You can add digital signatures to your Excel file. For more information, see Add or remove a digital signature in Office files. Note: To add a digital signature, you need a valid certificate from a certificate authority CA.

Workbook-level : You can lock the structure of your workbook by specifying a password. Locking the workbook structure prevents other users from adding, moving, deleting, hiding, and renaming worksheets. For more information on protecting workbooks, see Protect a workbook. If that's what you want, click Yes , otherwise No. Another way to share an Excel workbook is to save it to OneDrive, invite your colleagues to work on it, and see each other's changes instantaneously.

Microsoft calls it co-authoring. In Excel and Excel , to save a workbook to OneDrive, perform these steps:. In Excel , you can simply click the Share button in the upper-right corner, save the workbook to a cloud location OneDrive, OneDrive for Business, or SharePoint Online library , type email addresses in the Invite people box, separating each with a semicolon, and then click the Share button on the pane please see the screenshot below.

Clicking the Share button will send an email message to each person, a copy will be sent to you too, just in case. If you'd rather send the link yourself, click Get a sharing link at the bottom of the pane instead. Now, as soon as other people start editing the workbook, their names will appear in the upper-right corner sometimes pictures, initials, or even "G" that stands for guest. You can see other users' selections in different colors, your own selection is traditionally green:.

If multiple users are co-authoring, and you lose track of who is editing a specific cell, click on that cell, and the person's name will be revealed. To jump to the cell being edited by someone, click their name or picture, and then click the green box with the cell address. This is how you can share an Excel file with other users. I thank you for reading and hope to see you on our blog next week!

How to share Excel file for multiple users and co-author a shared workbook by Svetlana Cheusheva updated on March 3, How to share Excel file for multiple users How to share Excel workbook and protect change tracking Limitations of shared Excel file How to edit Excel shared workbook Resolve conflicting changes in a shared workbook How to merge different copies of a shared workbook Remove users from Excel shared workbook How to unshare a workbook in Excel Share Excel workbook using OneDrive How to share an Excel file This section shows how to share an Excel workbook for multiple users by saving it to a local network location where other people can access it and make edits.

With the workbook open, perform the following steps to share it: On the Review tab, in the Changes group, click the Share Workbook button. The Share Workbook dialog box will appear, and you select the Allow changes by more than one user at the same time.

This also allows workbook merging check box on the Editing tab. Optionally, switch to the Advanced tab, select the desired settings for tracking changes, and click OK.

Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information.