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
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 .
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 .
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 .
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 .