If you're using Office 365 (the subscription version of Office 2016), then no, you won't find an update option
Thanks for pointing that out. You're the first person who actually mentions this!
That at least adds some clarity to the discussion.
(We're using the subscription version because this is the only version that is easily available here locally.)
You mention that it is supposed to update automatically but it doesn't seem do it immediately although I am daily connected to a proper internet connection at the office.
Version 16 seems to be out for a while now but I was still stuck on a version 15.
But unfortunately no way to force an update.
For all people with similar issues :
As a last resort I finally completely removed Excel because there is no way to force an update.
Here you can download the latest version and install it again :
Update history for Office 2016 for Mac - Office Support
After downloading it will use the original license so after installing you can start right away.
It seems to have solved some of the silly things Excel would crash on like selecting cell colors.
That you are having problems does not mean the entire Mac community is having problems. If it were actually that awful, you'd be reading about it all over the web.
Well, I read the same problems all over the web.
And those are people who have taken the effort to write about their problems.
Most people just read in order to find a solution for their problems (including myself).
On the official forums from Microsoft, all moderators just pretend that everything is just an isolated case and repeat the same standard answers over and over again.
But in most cases, people can clearly point out how to reproduce the issue, followed by a dozen users who have taken the effort to mention that they have the same issue.
In comparison to other software vendors, it's hard to file a bug report with Microsoft as if their products are without any issues.
The 2016 version is actually the most parity feature equivalent version of Office MS has ever released.
In terms of features it's maybe close to the PC version, but it is not stable enough.
Every update seems to introduce new bugs of which one wonders if they could not have been caught during testing.
I mean, a full application crash on something simple as selecting a color?
I've worked with Excel for over 10 years on many PC's and a crash is almost unthinkable.
After starting to work Office with a Mac, I realized the luxury of being able to rely on software not to crash.
Usually Apple will put some pressure on software developers if applications are crashing frequently on certain products. But Microsoft circumvents this Apple crash reporter and only Microsoft gets a notification.
I think that is also something that Apple needs to address.