Apr 01 2021 08:53 AM
Hello, I have followed the instructions provided online for using Track Changes (Legacy) in excel; however, no matter how many times I try to change a cell and track it and make sure the highlight changes button is activated, excel is not recording certain changes that I've made. Can you please assist with this.
Apr 01 2021 11:03 AM
Apr 01 2021 11:21 AM
@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.
Apr 01 2021 11:52 AM
@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?
Aug 17 2022 09:54 AM
Aug 17 2022 12:23 PM
Aug 17 2022 02:13 PM
Dec 20 2023 12:28 PM
I posted a request for help about 18 months ago. Nothing substantive has been forthcoming in the intervening year and a half.
My takeaway is that this function does not work. It would be nice if someone from Microsoft could confirm that this is an unresolved issue as I will have to explain this failure to a client.
Dec 20 2023 12:43 PM