Unless it's changed in recent versions Excel isn't threadsafe, so using realtime updates is something that works 99.9% of the time and blows up the other time leaving no evidence behind it when it comes to audit.