...
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.
...
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.
...