WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel Shared Workbook

Excel Shared Workbook

Procedure Involved in Sharing Excel Workbook

Follow the below steps to learn about this option.

  • Step 1: First things is we need to decide which workbook that we want to share, so open that excel workbook first.
  • Step 2: In that workbook, go to the Review tab and click on the Share Workbook option in Excel.

Excel Share File

  • Step 3: As soon as you click on the Share Workbook, it will show you the below dialogue box. In this below the window, we have two tabs, i.e., “Editing” & “Advanced” under the editing option, select the checkbox ‘Use the old shared workbooks feature instead of the new co-authoring experience.’

Excel Shared File 1

  • Step 4: Under Editing, that was the only option we have, now choose the Advanced tab. Under Advanced, we can track changes, when to track changes, the conflict between two users’ changes at a time, etc…

Excel Shared File 1-1

  • Step 5: After all the settings we have done in the above window, we need to upload the file to a network location like dropbox from where they can access the workbook. Then send the link or give the user id password to them.
  • Step 6: Send the workbook stored link to the concerned person.

Errors in Excel Share Workbook

Often times, when you choose the option “Share Workbook,” it shows the error message. The reason behind this is some settings in excel.

Follow the below steps to change settings.

Go to File >>> Options >>> Trust Center >>> Trust Centre Settings >>> Uncheck Remove personal information from file properties on view.

Error in Share Workbook

Excel Share Workbook but Also Protect Changes Tracking

Sharing Workbook isn’t only featured available rather, we can foresee the changes of other users as well. To apply this change, we need to un-share the workbook before we apply any changes.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

To check the changes of users and have control follow the below steps.

  • Step 1: Go to Review Tab.
  • Step 2: Next to “Share Workbook,” we have the Protect Shared Workbook option; click on that.

Protect Changes Tracking 1

  • Step 3: Once you click on the “Protect Shared Workbook,” we can see below the dialogue box. Under Password (optional), enter the password as per your wish but remember it!!!.

Protect Changes Tracking 1-1

  • Step 4: Password isn’t the mandatory option; however, it is always a good practice to enter the password and share the workbook to have control over the changes.

Protect Sheet vs. Protect Shared Workbook

We can see two types of protection with excel, i.e., “Protect Sheet in Excel” and “Protect Shared Workbook.” Don’t get confused with these two options; these two aren’t the same; below are the differences between these two.

  • Protect Sheet is protecting the worksheet, not the workbook
  • Protect Shared Workbook means we are not allowing the user the option of change tracking of the shared workbook.

Un-Share & Remove Users From Shared Workbooks

We can also un-share and remove particular users from the shared workbook.

To un-share the workbook, we need to uncheck the option of “Use the old shared workbooks feature instead of the new co-authoring experience.”

Workbooks 1

If you wish to remove users, then we need to select the user and check the “remove” button, as shown below.

Workbooks 1-1

This will remove the selected user from this workbook.

Things to Remember

  • We need to protect the shared workbook and share to track changes option.
  • Protect Worksheet and Protect Shared Workbooks aren’t the same.

Recommended Articles

This has been a step by step guide to Excel Shared Workbook. Here we provide step by step guide to share files in excel along with examples and explanations. You may learn more about excel from the following articles –

  • 5 Types of Excel Auditing Tools
  • Unprotect Workbook in Excel
  • What is Power Query in Excel?
  • How to Protect Workbook in Excel?
  • Apple Numbers vs. Excel
3 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More