...
To refresh all, you do not have to highlight an anchor cell and can simply click on the lower section of the Refresh icon and you will be prompted to Refresh All.
...
VBA Refresh
To invoke a refresh via a Visual Basic (VBA) command, please click here.