EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Excel Excel Resources Excel Tips Share Excel Workbook

Share Excel Workbook

Jeevan A Y
Article byJeevan A Y
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated June 2, 2023

Share Excel Workbook

Share Excel Workbook

The share Excel Workbook option is available under the Review menu tab under the Changes section, which is used to share the worksheet with any organization recipient if they are connected using MS Outlook. It allows the other recipient to review the document or file and make the changes. We can also highlight the changes done by other users and accept or reject those changes if they do not match the criteria.

ADVERTISEMENT
Popular Course in this category
FINANCIAL MODELING & VALUATION Course Bundle - 51 Courses in 1 | 30 Mock Tests | World's #1 Training

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

How to Share Excel Workbook?

In this section, we will see how to Share Excel Workbook.

Follow the below steps to explore this cool option.

You can download this Share Workbook Excel Template here – Share Workbook Excel Template

Step 1: Open the Excel Workbook you want to save.

Step 2: Go to the Review tab and find the Share Workbook option.

Share Workbook

Step 3: After clicking on the Share Workbook, it will show you the new dialog box. Under the Editing option, select the checkbox “Allow changes by more than one user at the same time. This also allows workbook merging.”

Editing option

Step 4: Now select the Advanced tab under the same dialog box. This section shows the options Track changes, Update Changes, Conflicting changes between users, and Include in personal view under this section.

Advanced option

Step 5: Now save the workbook to the network location where the authorized person can access it and give them the link to the workbook folder, and you can also pass the link to your colleagues.

Change settings if your share workbook option is showing the below error:

If you click on Share Workbook and show the error message, you must change some settings.

  • Go to File > Options.

Options

  • Trust Center > Trust Centre Settings.

Trust Center

  • Click on Privacy Options > Uncheck “Remove personal information from file properties on save “.

Privacy option

Note: First, you need to unshare the workbook and apply password settings.

Concept of controlling history changes in the workbook:

You can protect and share the workbook if you want to share the Excel Workbook and control changes history. Find the below steps to apply this function.

Step 1: Go to the Review Tab.

Step 2: Click on Protect Shared Workbook.

Protect Shared Workbook

Step 3: It will open the dialog box. Click on the dialog box and enter your password.

Entering the password

Step 4: Password is not mandatory, but it is always safe to protect and share to control the other person’s changes.

Protect Worksheet vs. Protect Shared Workbook

  • Protecting the worksheet is nothing, but you do not authorize the user except for specific cells.
  • Protect Shared Workbook means that you just turn off the option of tracking changes to the option of monitoring changes in the shared workbook.

Merge Multiple Shared Workbooks:

  • If many people or users change the workbook, you can work together and merge with Excel Compare & Merge.
  • Finally, you receive all the shared workbooks and save all the workbooks in a single folder. After that, select the Compare & Merge Workbooks option and individually select the workbook you want to compare and merge.

Unshare & Remove Users From Shared Workbooks:

  • You can do this if you want to unshare and remove users at any point.
  • To unshare the workbook, go to REVIEW and click on Share Workbook.

Protect and Share Workbook

  • Now uncheck the option of Allow Changes by more than one user simultaneously.

Uncheck Allow Changes

  • To remove users in the same window, select the user you want to remove and click the remove user option.

Remove User option

Things to Remember

  • While performing in the Share Excel Workbook, always protect the workbook from controlling the track changes option.
  • Protect Worksheet and Protect Shared Workbooks are both different from each other.
  • You can select which changes you want to apply or remove at any time.
  • It is a feature that automatically adjusts the width or height of a cell. The easiest way to adjust a column is to use the Share Excel Workbook.

Recommended Articles

This has been a guide to Share Excel Workbook. Here we discuss how to use Share Excel Workbook, practical examples, and a downloadable Excel template. You can also go through our other suggested articles to learn more –

  1. Unprotect Excel Workbook
  2. Protect Excel Workbook
  3. VBA Workbook
  4. VBA Workbook Open
ADVERTISEMENT
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
ADVERTISEMENT
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Share Workbook Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Share Workbook Excel Template

EDUCBA

डाउनलोड Share Workbook Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW