How to edit the same workbook by multiple people in excel?
Pretending to be a gentleman 2020-11-26 16:27:22
Excel skill :Excel How to edit the same workbook by multiple people ?

To achieve Excel Multi person editing and final revision of data , We need to do the second step of today , It is to share our workbooks and documents .

scene : Office workers who are suitable for multi person collaborative revision and data tracking .

problem :Excel How to edit the same workbook by multiple people

answer : utilize Excel Protect and share workbooks in the review function in !

The specific operation is as follows : stay “ Review ” in , single click “ Protect and share workbooks ”, The figure below 2 It's about


Excel How to edit the same workbook by multiple people ?


In the new pop window , tick “ Share in tracking revisions ”, You can also set the password as needed . But there's no password here , In this way, individuals can make comparisons and merge workbooks more efficiently . The figure below 3 It's about .


Excel How to edit the same workbook by multiple people ?


Click on the “ determine ” After button ,Excel Will ask to save the workbook . Pay attention to the changes in the files , It will show that there are two shared words . Here's the picture 4 It's about .


Excel How to edit the same workbook by multiple people ?


It should be noted that once the workbooks are implemented “ share ” After setting , Most of Excel The function will be turned off until it is out of use . But it doesn't affect our skills 228 To talk about the revision and tracking function of .


Excel How to edit the same workbook by multiple people ?

summary : Comparing and merging workbooks is Excel An advanced utility feature of , It's a great way to work in a way that requires teamwork to modify data , It is very convenient for decision makers to determine the final data . This issue introduces the second step to implement this function : open Excel Sharing settings for workbooks .

The technique Excel2007 Version and above are valid .

版权声明
本文为[Pretending to be a gentleman]所创,转载请带上原文链接,感谢
https://fheadline.com/2020/11/20201126162645800w.html
相似文章

2021-08-09