Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Track Changes Excel 2000

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rob E - 27 Mar 2008 19:29 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.