Forum Discussion
Track Changes in Excel disappearing and/or not showing after saving
mtarler Yes, it is sporadic and would keep the highlighted changes in certain cells but not others. I checked and they are mainly text > text changes, no formulas or reformatting etc. Do you know how to resolve that? And in the case it is changes cells with formulas/reformatting, what is the process to fix that issue (if they are different)? Thanks.
astp1560 I don't know of problems with it and it is really hard to help without something I can re-create or maybe if you can show specific example. There are a couple of menu things you should double check. The main track changes menu:
gives many options based on when, who, and where. make sure that isn't excluding the cells or people you are trying to track. Another nice feature is the last item which is "List changes on a new sheet". To use that FIRST hit save (it will only list items that have been saved) then go into this menu, click the box and click OK. Then a new sheet is created with a log of each change that has been made. This is particularly nice to see previous changes and not just the latest change. Have you tried this? Do those "missing" changes show up on this sheet?
Another menu to check is the Share Workbook (legacy) command window:
This feature has to be turned on to use the track changes but it is automatically enabled when you make changes in the other menu. I believe the above example is the default value (30 days) and you might want to increase that. Any chance the changes you are 'missing' have gone past that default 30 day tracking?