Track Changes in Excel disappearing and/or not showing after saving

New Contributor

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.

3 Replies
Can you give more information and may supply a sample sheet that shows your issue? I just tested track changes in my sheet and it is still working for me. You say "certain changes", does that mean it is working for other changes? which changes does it not work for you? I believe it will only track value changes not format changes or changes in resulting values from formulas (only if you change the formula itself), is that your concern?

@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?