After further rigorous testing, the synch from Forms data to Excel isn't reliable automatically. Even manual refreshes have ~85% probability of working.
Often the changes never come through in a time frame we'd expect from an international software giant. I just don't think Microsoft respects its customer base when it releases such poorly tested basic features. As it stands, Microsoft Forms is semi-useful for a trivial quiz or two.
That's pathetic - it should be so much more than this - but it isn't - due to incompetent development management and testing.
We all want scalable and reliable solutions so we can gather tens of thousands or even millions of survey responses.
We rightly should have little confidence in Microsoft to deliver business quality solutions when they are released with so many blatant and basic bugs.
(I'm someone who supported Microsoft products for 15 years being the first to implement MS Dynamics over media organisations.)
The Asynch engine in hosted MS Dynamics had all the "qualities" of the poor synchronisation we now regularly now encounter in M365.
Often poor reliability, poor speed, poor integration, buggy and difficult to diagnose - even though in theory it should have been so much better.
If we keep on paying Microsoft the money when they release poorly performing software, they simply don't get the message. Vote with your feet, vote with your wallet - simply migrate away from Microsoft products that don't deliver first time. Let decision makers in your organisation know that Microsoft has too many bugs and the competition has more features and is well tested. If we don't alert them, then we are part of the Microsoft problem too.
Unfortunately, Microsoft currently represent poor return on investment compared to 90% of the competition.
Microsoft - Now listen..... Ready? Here's your chance.....
Test your software. Sort out the basics. Sort out the bugs. You are not working well enough for us. Invest heavily in testing.
Microsoft is not the "business standard" anymore.
Microsoft is now the "business sub-standard" and we both know IT.
Microsoft