How Do I Make an Excel File Editable by Multiple Users? How to Share a Document

Select Share. Select permissions and then Apply. Add people. Type a message if you like. Select Send. Follow these steps: Select SHARE. Select permissions and then APPLY. Add people. Type a message if you like. Select SEND.

How do I turn an Excel File into a shared document?

Click Share in the upper-right. Click Invite People. Type email addresses, separate each with a semicolon. Make sure to select Can Edit. Select SHARE. Select permissions then APPLY. Add people. Type a message if you like. Select SEND. Click the filename to open it if uploaded. The workbook opens in a new tab in your web browser. Click EDIT IN EXCEL or EDIT IN BROWSER, then EDIT IN EXCEL after the page reloads if needed. Click OPEN MICROSOFT EXCEL. If in Protected View, click ENABLE EDITING. Click SHARE in the upper-right. Click INVITE PEOPLE. Type email addresses; separate with a semicolon. Click SHARE after selecting CAN EDIT. For direct sending, click COPY LINK > VIEW AND EDIT under SHARE. Emails will be sent if you clicked SHARE. The message comes from your email. You’ll also receive a copy. Recipients get an invitation email to open the file. They can edit in the browser or Excel app. For Excel 2016 for Microsoft 365, open directly via FILE > OPEN… > SHARED. Co-authoring allows multiple editors. Supported by Excel for Android, iOS, Mobile, and Excel 2016 for Microsoft 365. Otherwise, use EDIT IN BROWSER.

How do I make an existing Excel File shared?

On the Tools menu, click Share Workbook, then the Editing tab. Click to select Allow changes by more than one user, click OK. Save when prompted. To modify a shared workbook in Excel 97 or newer, use the corresponding version. For Excel 2007: Click REVIEW tab. Click SHARE WORKBOOK in the CHANGES group. On EDITING tab, select ALLOW CHANGES BY MORE THAN ONE USER AT THE SAME TIME, click OK. Save the workbook on a network location. For Excel 2003 and earlier: Follow similar steps and save on a network location for access.

How do I create a shareable and editable Excel spreadsheet?

Select Share. Set permissions. Allow editing is checked. Enter names or email addresses to share with. Add a message (optional). Select Send. Alternatively, select Copy link for a file link. After sharing, edit together for the best experience in Excel for the web. Colored cells indicate where each person is working. Click a color to see the editor. To see and restore past versions, select FILE > INFO > VERSION HISTORY. For comments, on the INSERT or REVIEW tab, select COMMENT, type, and select POST. A red triangle appears for comments. Select REVIEW > EDIT COMMENT to edit. Delete comments or show them using REVIEW options. If editing with others, chat by selecting CHAT, type a message, and press Enter.

Leave a Comment