Description

The LASTREFRESHBY function returns the Windows username of the person who last refreshed the specified connection in the current workbook.

Syntax

LASTREFRESHBY(Connection)

The LASTREFRESHBY function uses the following parameters:

Parameter

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager

Example

=LASTREFRESHBY("Demo")

Description

Returns the Windows Username for the last user to refresh the Demo connection.

Result

refreshby.png
Did this answer your question?