Is there a way of creating a chart that monitors events that numerous people can change and input data? These changes to be monitored then displayed, either in a list or graph format? Also, although this work book/sheet can be changed by many people, these changes will create an history which can be saved but not altered, only by the owner of this workbook. (Excel 2007)
Hi Sitting-Bull,
Tracking all the changes and then presenting it in chart form would be slightly difficult, but you can track the users who opens workbook with date & time stamping and this can also be presented via charts.
Track changes would be another alternative using which you can track the changes by users.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
I have a similar issue.
I would like Excel to automatically track all changes since the last time I opened the file, and have it present it in the new sheet. I am able to this manually, but I would like it to do this automatically once I open the worksheet. Is this possible?
Have a play with this code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks