This is nothing major, but is neat and can be useful. (If you are considering Office 365 or would like to know more, click here.) Instead you end up with your own copy of the file, and they have their online copy – which could become very messy!

If you do this, the file no longer syncs automatically with the other users. When you open Excel files through this route, you end up using your offline, full copy of Excel rather than the Online version. One further point to note is that it is possible to sync your OneDrive to your computer so that it becomes a standard folder on your PC. Apparently you can also use your SharePoint site by connecting the OneDrive to your SharePoint site. Be aware though that when using Excel Online, changes are saved to the file immediately, without choosing to click “Save”. 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.

Quick analysis button excel 2007