display last connection refresh time?

[merlin777]

I'm using auto refresh connections and want to put the time of the last connections refresh into a cell. Is that possible?

 

[igold]

If this is for the Google Finance page, you could just put =Now() on the Google sheet and import it with the table. It won't give you every time Excel updates the connection, but it will give the time that the Google sheet was last updated.

 

[merlin777]

excellent idea. Just accurate enough to let me know it's being updated OK.