J
Jaybee
Some data was entered into an Excel worksheet after a cut off date. I there a
way of telling when the data was entered.
way of telling when the data was entered.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
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
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
G
Gord Dibben
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("Last Save Time"), _
"yyyy-mmm-dd hh:mm:ss")
End Sub
Gord Dibben MS Excel MVP
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("Last Save Time"), _
"yyyy-mmm-dd hh:mm:ss")
End Sub
Gord Dibben MS Excel MVP
A
Ashish Mathur
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
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