Hi All,

I've currently got an Excel sheet linked up to a DB that refreshes every 15 or so minutes. unfortunately for the users they can't tell if the data has been refreshed just by looking at the sheet.

I'm trying to find a way of displaying the last modified date and time (maybe in a specific cell) upon opening the book. I've found information on how to show the date and time when printing a sheet but wondered if anyone knew how to display in the workbook itself?

Thanks

Nick