Track Changes Excel 2000

[Rob E]

My company are looking to implement track changes to all spreadsheets in
order to show the detailed history of all amendments made. We currently have
Excel 2000 and the problems we are facing are that if the same cells are
amended it will only show the latest and it also makes the workbook become
shared which I believe enables all approved users to open the spreadsheet and
make changes at the same time, but this is slowing down opening closing and
saving. Is there any way round these issues, as we require the whole history
to be shown and by enabling track changes does this automatically make the
workbook shared?

Any help would be appreciated.

 

[Gord Dibben]

You cannot track changes without the workbook being shared.


Gord Dibben MS Excel MVP

 

[JP]

What about event code that writes all changes to an external text file
(or spreadsheet, or .doc)?

--JP

 

[Gord Dibben]

Certainly but that was not the OP's question.


Gord