Question

the purpose of
share workbook and worksheet data in Excel?​

Answer 1

Explanation:

If you want several users to work in the same Excel workbook simultaneously, you can save the workbook as a shared workbook. Users can then enter data, insert rows and columns, add and change formulas, and change formatting.