X

We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
DISCOVER
×
Loading ...

How to Share Excel Spreadsheets

Updated April 17, 2017

Group collaborations with Excel spreadsheets are enhanced when those spreadsheets are shared. Sharing a spreadsheet enables multiple people to make changes to a document in a shared location. The owner of the spreadsheet can open it a later time and approve or reject changes made to the spreadsheet. Excel keeps a log of the changes and the owner can modify the amount of time for which the changes are tracked.

Loading ...
  1. Open Excel and select a spreadsheet to share. Select "Open" on the menu bar and browse your computer for the spreadsheet you want to share. Select the spreadsheet and click on "Open."

  2. Select the "Review" tab and "Share Workbook." The Share Workbook dialogue box appears. Click the "Editing" tab. Check the option for "Allow changes by more than one user at the same time. This also allows workbook merging."

  3. Click the "Advanced" tab. In the Track Change section, select "Keep change history for 30 days." The day value can be changed from 1 to 32,767 days. In the Update Changes section, select the option that reflects how you want the spreadsheet changes updated. In the Conflicting Changes Between Users Section, select the option that reflects how you want conflict changes handled. Click "OK."

  4. Save your shared workbook in a network location so others users can have access to it. The workbook will display the word "Shared" in the title bar to indicate that it is shared.

Loading ...

About the Author

Emmanuelle Douglas has been an avid writer since 1990. Her first professional writing assignment was for "Oscar News," a local corporate Intranet website. She holds a Bachelor of Science in mathematical sciences from Clemson University.

Loading ...