where is quick analysis tool in excel 2016

You can now share the workbook with others, see the changes everyone makes after they've made them, and decide which to keep and which to discard. This also allows workbook merging.' Then on the Advanced tab on the screen, select how you want to track changes and handle edits made by others - for example, for how long to keep the history of changes in the document. In the workbook you'd like to share with others, click Review on the Ribbon, then click Share Workbook, and in the Editing tab of the screen that appears, check the box next to 'Allow changes by more than one user at the same time. (Note that you can't share workbooks with Excel tables in them, and there are other limitations as to the formatting and features that can be performed in a shared workbook.) Still, if you often work with others on spreadsheets, you may want to try it out.įirst you need to prepare a workbook for sharing. Sharing in Excel has always been kludgy, and the Simple Sharing feature in Excel 2016 doesn't make things dramatically easier. Instead, it's only a way for people to more easily use the sharing features that have existed in one form or another since Excel 2007. In March 2016, the desktop version of Excel was given a feature called Simple Sharing, and some industry watchers believed that live collaboration for Excel was finally here. Of 2 Simple Sharing with the desktop version of Excel

Where is quick analysis tool in excel 2016