Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I track changes made to a shared file per userid.
I was wondering if I could track who made what changes in a shared excel
file. If so, how should I go about it? Thank you in advance! Julie |
#2
|
|||
|
|||
On that same Tools|Share Workbook dialog, there's an Advanced Tab.
There's an option (default is On???) that allows you to track those changes. When you're ready to look at the changes, tools|track changes|accept or reject changes (You may already have it turned on.) But be aware that if you keep lots of changes, then excel can slow down. Julie _at_GBS wrote: I was wondering if I could track who made what changes in a shared excel file. If so, how should I go about it? Thank you in advance! Julie -- Dave Peterson |
#3
|
|||
|
|||
Hello Dave,
Thank you for your input. I know doing this will track the actual changes made to the spreadsheet, but will this also track who made the changes? I need to know the person or userid who is making the changes. Any suggestions would be greatly appreciated. Thanks again! Julie "Dave Peterson" wrote: On that same Tools|Share Workbook dialog, there's an Advanced Tab. There's an option (default is On???) that allows you to track those changes. When you're ready to look at the changes, tools|track changes|accept or reject changes (You may already have it turned on.) But be aware that if you keep lots of changes, then excel can slow down. Julie _at_GBS wrote: I was wondering if I could track who made what changes in a shared excel file. If so, how should I go about it? Thank you in advance! Julie -- Dave Peterson |
#4
|
|||
|
|||
It showed who made the changes when I did tried it. Did it not show the user
name for you? Julie _at_GBS wrote: Hello Dave, Thank you for your input. I know doing this will track the actual changes made to the spreadsheet, but will this also track who made the changes? I need to know the person or userid who is making the changes. Any suggestions would be greatly appreciated. Thanks again! Julie "Dave Peterson" wrote: On that same Tools|Share Workbook dialog, there's an Advanced Tab. There's an option (default is On???) that allows you to track those changes. When you're ready to look at the changes, tools|track changes|accept or reject changes (You may already have it turned on.) But be aware that if you keep lots of changes, then excel can slow down. Julie _at_GBS wrote: I was wondering if I could track who made what changes in a shared excel file. If so, how should I go about it? Thank you in advance! Julie -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Yes, it does now when I choose "List changes in separate worksheet" - it
displays the user along with other information on a separate worksheet. Again, thank you for your help and your time! Julie "Dave Peterson" wrote: It showed who made the changes when I did tried it. Did it not show the user name for you? Julie _at_GBS wrote: Hello Dave, Thank you for your input. I know doing this will track the actual changes made to the spreadsheet, but will this also track who made the changes? I need to know the person or userid who is making the changes. Any suggestions would be greatly appreciated. Thanks again! Julie "Dave Peterson" wrote: On that same Tools|Share Workbook dialog, there's an Advanced Tab. There's an option (default is On???) that allows you to track those changes. When you're ready to look at the changes, tools|track changes|accept or reject changes (You may already have it turned on.) But be aware that if you keep lots of changes, then excel can slow down. Julie _at_GBS wrote: I was wondering if I could track who made what changes in a shared excel file. If so, how should I go about it? Thank you in advance! Julie -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared Excel File keeps growing........ | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
restrict opening Excel file residing on a shared drive to one user | Excel Discussion (Misc queries) | |||
File is locked for Editing by user problem | Excel Discussion (Misc queries) |