If you are working with various worksheets in a workbook then you might have grouped the worksheet for a working purpose. Ungroup Worksheet to Activate Track Changes Option In summary, the workbook is shared and we have successfully enabled track changes feature in excel.ģ.Hence, from the window check mark the “ Use the old shared workbooks feature instead of the new co-authoring experience”.Therefore, a new window will open named “ Share Workbook”.Above all, click the “ Share Workbook” option from the “ Review” option.Track changes option becomes greyed if you have not shared your workbook on your system or a drive. Enable Share Workbook to Solve This Issue Read More: : Track Changes Not Showing in Excel (with Easy Fix)Ģ. Now, if we change the value from one cell you will see the track changes feature will show the change in a comment box confirming the tracking of changes in the workbook.Then, check mark the “ Track changes while editing.Therefore, a new dialog box will open named “ Highlight Changes”.In order to check if the feature is working or not let’s click the “ Highlight Changes” from the “ Track Changes” ribbon.Finally, you will see the “ Track Changes” option is no more greyed out.Second, type the password to unprotect the worksheet.First, from the “ Review” option select “ Unprotect Sheet”.Just unprotect the workbook and enjoy the track changes feature. One of the reasons is that your workbook is protected with a password. The track changes option becomes greyed due to various reasons. Now, we are going to solve this greyed out problem by enabling the greyed out option in excel. As you can see from the following screenshot the “ Track Changes” option is greyed out. Suppose we have a dataset of some Products and their Total Sales. In the following article, I have shared 3 Simple methods to solve track changes greyed out in excel. The main reasons behind it are-ģ Easy Fixes to Solve Track Changes Greyed Out in Excel But sometimes you will find the track changes option is greyed out. Track Changes option is one of the best features of excel where you can track and review your changes and other multiple user changes. Reasons Behind Track Changes Option Gets Grayed Out in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |