We have several users in our company that are working with similar and interconnected data in Excel. I would like to speed up their work and make it simpler by sharing Excel workbook so they can all work on the same work book at the same time. Can you explain to me how to configure this in excel.
Hello. Excel spreadsheet sharing can be set by following this procedure: Open Excel, go to Tools menu an select "Share Workbook". When Share Workbook dialog appears select option to allow multiple users to change data at the same time. Click OK and save workbook. When you reopen it you should see [Shared] at the end of file name in the title bar if everything went well.