Some data was entered into an Excel worksheet after a cut off date. I there a
way of telling when the data was entered.

Hi,

Not with any level of certaintity there isn't. You have the last modified
date/time in File|properties but this won't tell you which data are changed
only that the workbook was changed on a certain date.

If this is important to you then for the future you may consider
time-stamping data entries with VB code and if you need that post back with
details and i'm sure someone will help.

Mike

"Jaybee" wrote:

Some data was entered into an Excel worksheet after a cut off date. I there a
way of telling when the data was entered.

For individual cells, none that I know of.

You could find the last saved date/time which might tell you something
assuming you have a backup of the version at cutoff date for comparison.

Sub dateit()
ActiveSheet.Range("A1").Value = "Last Saved : " & _
Format(ThisWorkbook.BuiltinDocumentProperties("Las t Save Time"), _
"yyyy-mmm-dd hh:mm:ss")
End Sub


Gord Dibben MS Excel MVP


On Tue, 30 Sep 2008 00:01:01 -0700, Jaybee
wrote:

Some data was entered into an Excel worksheet after a cut off date. I there a
way of telling when the data was entered.

Hi,

For future reference you can use the Track changes feature of Excel - jus
that after tracking changes, the workbook gets "shared" and some features
may be unavailable. Please read up more in the Help menu

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jaybee" wrote in message
...
Some data was entered into an Excel worksheet after a cut off date. I
there a
way of telling when the data was entered.