Tracking the date a cell was last changed

papercontracts

New Member
Joined
Jul 24, 2007
Messages
4
Hi. Can anyone tell me if there's a way to see the date when an individual cell was last changed in a spreadsheet? Thanks, David.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
Edit**

Hi Papercontracts!

Tools> Track changes> highlight changes>
Choose When> All
Who> Everyone
Where> Choose your cell eg A1.

You can choose to track changes by a comment in cell or changes can be stored on a sheet whcih you could just hide or password protect.

Hope this helps
PS Welcome to the board!!
 

papercontracts

New Member
Joined
Jul 24, 2007
Messages
4
Hi. Thanks for the welcome, and for the answer. However I want a 'last changed' date that persists when the document is saved and re-opened. With Track Changes, that info is lost when the document is saved, I think. David
 

Forum statistics

Threads
1,181,649
Messages
5,931,216
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top