This means that multiple users will be making changes to the document. Whenever your turn on tracking, the workbook becomes a shared workbook. That means the next time you open it, you won’t be able to see that change you had made 45 days earlier.Ĥ. When you close it, any change history older than 30 days will be gone. If you make changes to an Excel worksheet and then open the workbook again 45 days later, then you’ll be able to see the change history for all 45 days until you close the workbook. Change history is only kept for 30 days by default. Other changes that are not tracked include hiding/unhiding rows and columns, comments, and cell values that change to due a formula recalculation.ģ. Any data stored in a cell is tracked, but other changes like formatting are not. Turning on tracking doesn’t mean every single change you make will be recorded.
0 Comments
Leave a Reply. |