Learn Excel - Multiple People Editing Workbook - Podcast 2157
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.
Changes to other endpoints are shown in a few seconds.
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.
Видео Learn Excel - Multiple People Editing Workbook - Podcast 2157 канала MrExcel.com
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.
Changes to other endpoints are shown in a few seconds.
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.
Видео Learn Excel - Multiple People Editing Workbook - Podcast 2157 канала MrExcel.com
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Sharing an Excel file and tracking changes made by users: Excel 2013 / 2010 / 2007Excel Real Time Co-authoring - Better than Google Sheets!50 Ultimate Excel Tips and Tricks for 2020How To Share and Sync Your Macro-Enabled Excel Workbook, from Scratch, With Anyone In The WorldThe AMAZING TRICK To Add Different User Security Rights to ANY Excel Sheet and User LoginMake 1 Excel file allow Multiple Users at the same time | NETVNEXCEL: Co-author, share, use @mentions & Forms on SharePoint & TeamsHow to Create a MULTI-USER, macro enabled, Excel Workbook WITHOUT Using 'Share Workbook'8-7: Edit a Workbook Simultaneously With Others Using Excel Online3 Ways to Draw and Create a Floorplan In EXCEL like CAD with Examples!Collaborate better using Sheet View in ExcelHow to work with multiple users on an Excel worksheet?7 Ways To Protect an Excel Workbook From Editing | AdvancedMicrosoft Excel 2016: Share Excel using the OneDriveLearn Excel - Slicer For Two Data Sets - Podcast 2198Microsoft Excel Tutorial - Beginners Level 1WHO CHANGED YOUR DATA? Excel's NEW "Show Changes" will Tell YOU (Formula changes too!)Excel Subtotals Are Awesome - 2428How to share a worksheet with others in Office 365 Excel? PresentationPoint