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.

Signature
Thanks,
Rob E.
Gord Dibben - 27 Mar 2008 22:25 GMT
You cannot track changes without the workbook being shared.
Gord Dibben MS Excel MVP
>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
[quoted text clipped - 7 lines]
>
>Any help would be appreciated.
JP - 28 Mar 2008 03:11 GMT
What about event code that writes all changes to an external text file
(or spreadsheet, or .doc)?
--JP
> You cannot track changes without the workbook being shared.
>
> Gord Dibben MS Excel MVP
Gord Dibben - 28 Mar 2008 04:32 GMT
Certainly but that was not the OP's question.
Gord
>What about event code that writes all changes to an external text file
>(or spreadsheet, or .doc)?
[quoted text clipped - 4 lines]
>>
>> Gord Dibben MS Excel MVP