There needs to be a "track changes" button like the one on Microsoft word.
Word has an icon and ability to track changes to your document. This needs to be installed on Excel instead of leaving comments. This makes it easy to work with when sending an excel document to other people.
There is already a track changes button on the Review tab of the ribbon (enable it by first selecting “share workbook”).
However, selecting this item does limit the types of changes you can make in your workbook, so you may find that it’s not as useful as you’d like.
Longer term, we want to build a system that tracks changes made by users via a service so that you can go back to any point in time in a spreadsheet’s life.
when I select the review tab the unshare workbook is greyed out - how do you get round this please?
There is, but it's absolutely useless.