Excel for Mac stops updating share prices since latest update

Morning 🙂

I have an Excel spreadsheet that tracks some stocks with a macro that does a 'Refresh All' every minute. I noticed it stopped updating the data sources a couple of days ago (which I'm pretty sure coincided with an Excel update), I just tried the same spreadsheet on a Windows machine and it works perfectly so it would appear to be a problem with Excel for Mac itself. It's not a problem with the macro as it also doesn't update if I manually 'Refresh All'. Anyone got any ideas please?