Is there a function that will output the date and time of the last occurence
of a user refreshing a data source in Excel?

Thanks in advance for the replies,

Grant.

How can this then link into the user clicking the Refresh button? Maybe I
could record the date/time of the last save of the workbook?

"Patrick Molloy" wrote in message
...
no
but why not just add a line of code like
ThisWorkbook.Names("UpdateTime").Value = Now
where UpdateTime is a named cell

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"Grant" wrote in message
...
Is there a function that will output the date and time of the last
occurence
of a user refreshing a data source in Excel?

Thanks in advance for the replies,

Grant.