However, track changes is not on at this point.
If you start with a brand new workbook, and then choose to share it (Tools | Share Workbook), Excel allows others to access and modify the workbook.The two features are intimately related to each other. Unfortunately, Excel is rather confusing when it comes to sharing a workbook and tracking changes. If you want to still continue sharing-without tracking-then you may wonder what your options are.
If you turn it off, Excel assumes you also want to stop sharing the workbook, so it automatically turns off sharing. After all, change tracking is meant to be used in an environment where multiple users access and change the same workbook.Īt some time you may want to turn track changes off, so that they are no longer noted in the workbook. When you turn on change tracking, Excel requires that you share the workbook. Excel allows you to track changes made to a workbook, as described in other issues of ExcelTips.
