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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com