Sharing the workbook allows multiple people to access and edit it at the same time. It's a disaster because it's a badly implemented feature that leads to corruption and weird behaviour more often than not. I strongly recommend you not to use it, but if you do, make sure you have regular backups of the file as you will need them.