Рет қаралды 169,728
Microsoft Excel Tutorial: Collaborating on the Same Excel workbook.
In this video, we dive into the world of collaborative Excel editing and how to work together on the same workbook simultaneously without the chaos of traditional file sharing. Have you ever experienced the frustration of trying to edit a workbook with multiple collaborators? It often leads to locking conflicts and confusion.
In this tutorial, we'll explore the power of co-authoring in Excel, a game-changer for those using Office 365, Excel for iPad, or Excel Online. The key to co-authoring is saving your workbook on OneDrive or SharePoint, and the possibilities are endless.
No more worries about who has write access and who's stuck with read-only access. Co-authoring allows you to collaborate seamlessly, with everyone having the freedom to edit the file in real-time. We'll show you how to set up sharing links and manage access effortlessly.
We'll also demonstrate the real magic of co-authoring - multiple people editing the same workbook at the same time. Watch as changes happen almost instantaneously, with cell values updating in real-time. It's a fantastic way to work together on spreadsheets, especially for teams using Office 365 on Windows.
But, we also explore some of the quirks, like what happens when two people edit the same cell simultaneously, and who wins the race to press "Enter." And remember, co-authoring comes with an occasional companion called "Autosave," which has its pros and cons. We'll share more about it in the video.
So, if you're ready to embrace the future of collaborative Excel work, join us as we navigate the ins and outs of co-authoring. Whether you're a seasoned spreadsheet pro or just getting started, this feature can transform the way you work. Don't miss out on the power of co-authoring and discover how it can streamline your collaborative efforts in Excel.
Table of Contents
(00:00) Co-Authoring in Excel
(00:13) Old Way: Read-Only After 1 Person Opened
(00:32) Shared Workbook Limitations
(00:47) Auto Save icon Means Co-Authoring Available
(01:06) OneDrive or SharePoint
(01:26) See Which Cells Are Being Edited by Others
(02:16) Changes Sync Across Computers
(03:10) Share Workbook with Co-Worker
(03:55) Old Excel? Edit in Browser
(04:36) Two People Edit Same Cell at Same Time?
(05:57) Stay Away If Someone Else Edits
(06:39) iPad Excel to Highlight Cells or Camera
(07:59) Hate for AutoSave
(08:38) What is working well
(09:12) Unsupported Feature.
(09:46) Save a Copy Creates a Fork
(10:49) Easier to Just Lose Changes
(11:54) Episode Recap
(12:20) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelcollaboration
This video answers these common search terms:
how to share and collaborate excel document
how to enable multiple people editing excel
how to do that multiple people can work at one excel
how share excel workbook
how share workbook excel 365
how to share excel file with others
how to share excel workbook online
how to share excel workbook to multiple users
how to use shared excel file
how to do a shared excel file
how to make shared excel file
how to make shared workbook in excel
how create a shared file in excel
how to make a workbook shared excel
how to collaborate on excel document
can multiple people edit an excel
can multiple people edit excel at the same time
how to view excel with multiple people
can multiple users work in excel at same time
how can multiple users work in the same excel workbook
how to have multiple users in excel workbook
how do i share excel with multiple users
how to share excel file for multiple users
how to share a excel file with multiple users
how share a excel spreadsheet with multiple users
how to have multiple people edit excel
How can two people edit the same Excel workbook at the same time?
This feature has been introduced in 2017 and is available to anyone using Office 365, Excel online, or Excel on the iPad.
In order to co-author, the workbook has to be stored on the OneDrive or SharePoint.
For regular features, like entering data and formulas, the co-authoring experience should be great.
A colored box shows which cells are being updated. These boxes update quickly.
There are ways to break it - using Pens on the Draw tab of the Ribbon is one way.
Excel might ask you to refresh the workbook on each endpoint if you hit one of these errors.
The message telling you that the workbook could not be uploaded and offering Save a Copy is useless - you
would be creating a forked version of the workbook.
Join the MrExcel Message Board discussion about this video at www.mrexcel.co...