It's not possible to undo changes in Excel In that case, convert your tables to ranges and remove XML maps.ģ. If the Track Changes button is unavailable (grayed out) in your Excel, most likely your workbook contains one or more tables or XML maps, which are not supported in shared workbooks. Track Changes cannot be used in workbooks that contain tables For more information, please see our Excel shared workbook tutorial.Ģ. Not all Excel features are fully supported in shared workbooks including conditional formatting, data validation, sorting and filtering by format, merging cells, to name a few. That sounds great, but sharing a file has its drawbacks too. So, whenever your turn on tracking in Excel, the workbook becomes shared, meaning that multiple users can make their edits simultaneously. Track Changes is only available in shared workbooksĮxcel's Track Changes works only in shared workbooks. To use the Excel tracking feature most effectively, there are a few points for you to remember.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |