How can I track the date of changes to a spreadsheet ?

S

Sharon06

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
 
T

taskmaster

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!
 
G

Gord Dibben

Note: this will make the workbook "shared" with all the attendant loss of
functionality of shared workbooks.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do count a cell range that include all dates prior to today? 3
Need Help !! How to Copy a data from one spreadsheet to another 2
tracking changes to cells 3
stock control help 1
How can I track users who access a spreadsheet? 2
Spreadsheet to track payments 1
How can I track changes to a cell in Excel? 17
Track Changes Excel 2000 3

Top