| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I track the date of changes to a spreadsheet ?
Can anybody help.
I have taken over the use of several spreadsheets that have been updated without a rev/ date amendments. Is there any way I can track the date of any access/ update to them? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I track the date of changes to a spreadsheet ?
Hi Sharon,
On the Menu bar - Select Tools - Select Track Changes - Select Highlight changes This would enable you to view all changes made to the file from the moment the option has been enabled as a comment (just place the cursor on the cell where changes are made). However the date and time of changes depends on the Time/calender settings on your local system. Hope that solves! "Sharon06" wrote: Can anybody help. I have taken over the use of several spreadsheets that have been updated without a rev/ date amendments. Is there any way I can track the date of any access/ update to them? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I track the date of changes to a spreadsheet ?
Note: this will make the workbook "shared" with all the attendant loss of
functionality of shared workbooks. Gord Dibben MS Excel MVP On Mon, 3 Nov 2008 10:33:01 -0800, taskmaster wrote: Hi Sharon, On the Menu bar - Select Tools - Select Track Changes - Select Highlight changes This would enable you to view all changes made to the file from the moment the option has been enabled as a comment (just place the cursor on the cell where changes are made). However the date and time of changes depends on the Time/calender settings on your local system. Hope that solves! "Sharon06" wrote: Can anybody help. I have taken over the use of several spreadsheets that have been updated without a rev/ date amendments. Is there any way I can track the date of any access/ update to them? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| spreadsheet to keep track of phone numbers | Excel Worksheet Functions | |||
| How to report changes in a spreadsheet (not track changes) | Excel Discussion (Misc queries) | |||
| How do I track and save changes within an excel spreadsheet among. | Excel Worksheet Functions | |||
| Designing a spreadsheet to track workflow | Excel Worksheet Functions | |||
| Designing a spreadsheet to track workflow | Excel Worksheet Functions | |||
Linear Mode
