How to Share an Excel File on PC or Mac

This How.com.vn teaches you how to convert your Excel workbook to a shared document. This allows multiple people on the network to edit the same file.

1

Open the workbook you want to share.

Download Article

2

Click the "Review" menu.

Download Article

If you're using a Mac, it'll be in the menu bar at the top of the screen.

3

Click "Share Workbook."

Download Article

The Share Workbook option is on the toolbar. You'll see it in the “Changes” group on the ribbon. Look for the icon of a spreadsheet with a double-headed blue arrow.
- If you're not already on the Editing tab after clicking Share Workbook, click it now.

4

Allow multiple people to make changes at once.

Download Article

It’s at the top-left corner of this tab.

5

Click the "Advanced" tab.

Download Article

You'll see it to the right of the “Editing” tab.

6

Set the workbook to save automatically.

Download Article

Set your workbook to automatically save at a regular interval. Here’s how to do it:
- Click Automatically every under “Update Changes.”
- Select a number of minutes from the drop-down menu. The default is 15.

7

Click "OK."

Download Article

Now you’ll be prompted to save the file.^{[1]XResearch source}

8

Save the file.

Download Article

If you created a new file, type a name for the file now. If it’s an existing file, click OK to save your changes.

9

Click "Share."

Download Article

Look for the outline of a person with a “+” symbol.

10

Save the workbook to the cloud.

Download Article

A list of saving locations will appear.

11

Choose a network location.

Download Article

Click the network location on which you want to share the file. This will save the file to that location.
- For example, if you use OneDrive and so does the person you’re sharing with, select OneDrive.
- If you’re on a local network, select a network folder to which you and other sharers have access.