


In this mode, edits made by each user are seen in real time by other people using the file. the one that opens automatically if you log into OneDrive online and open an Excel file. Secondly, you all have to be editing it using the online version of Excel – i.e. Firstly, the file you are working on has to be stored in OneDrive.

There are a few caveats here in that this feature does not apply globally. The lack of multi-user capability has long been a bug-bear in Excel so this is a potentially very useful update. There is a very significant development in Excel 2016 when working in Office 365 - for the first time you can have multiple users editing a file at the same time. Like Access 2016, Excel 2016 is on the face of it very similar to its 2013 predecessor, but has a few tools and shortcuts added to make your life easier, plus the exciting advance in multi-user capabilities for Office 365 users.
