Refreshes the data in a data range returned to a worksheet from Microsoft Query. This function is equivalent to the Refresh button on the External Data toolbar.
Syntax
QUERY.REFRESH(reference)
Reference is the reference to a single cell inside a data range. If reference is not in a data range then the error value #REF! is returned.
Related Function
QUERY.GET.DATA Builds a new query using the supplied information
Return to index