Hello,
For me, I have noticed since Sunday (1st Aug 2021) that the stock data types now will automatically update when I open a workbook, switch workbooks or according to some timed refresh schedule ( I have not been able to figure out what the timing is between automatic refreshes). Before I had to press the refresh button to update them. I could not find a setting to turn off the automatic refreshes to make them manually update. I need to manually update, and the only way to stop the update is to disconnec the internet (not so convienent). Maybe there is a firewall setting to block the update?
Thanks
Thanks Anders,
I looked around in the settings, data connections and options and could not see anything.
Did not expect to find the refresh settings at the location. Time to change all my worksheets.
Thanks again, cheers