...
To turn the Auto Refresh off for historical data, click the “'Turn refresh off' option. Once off, historical data will update when manually updating the sheet.
...
VBA Refresh
To invoke a refresh via a Visual Basic Applications (VBA) command, please click here.