Show tracked changes in target file.

Question

I have some Excel files where I need to work in just one column, which I can do by hiding the other columns, and show the tracked changes in the target document.

I have edited the files with tracked changes on and can see the tracked changes in the Editor View in Studio. But when I Save As all the tracked changes have disappeared. Is there a way to show the tracked changes made in Studio in the target file?

Ben

Paul · Accepted Answer

Tyke said: Do you know if it's possible to get rid of the tags in review changes and to display the text as it shows in Studio, with the tracked changes? 
 As I said right at the start. Excel does not support tracked changes out of the box. You cannot do this without some development work in Studio and for Excel. 
 Regards 
 Paul

Paul · Answer

Hi Ben, 
 
Excel does not support tracked changes the same way Word does. I believe you can use shared workbooks and the whole cells are highlighted in some way, and maybe a note is added... but you won't be able to do this within a single excel file. At least I believe this is the case!! 
 
The only sensible solution you have really is to use the Studio review document which will show the tracked changes but of course this will be in Word. 
 
Regards 
 
Paul

Paul · Answer

You did make me more curious though as I'd never looked at this before in Excel. So it works like this: 
 
 So quite hard to see I deleted the word "more" in this cell. You'd have to get at every comment and then inspect the text to see what changes were made. Not very helpful. 
 I then found this post from Rosalyn Newell which looks pretty interesting: 
 
 It shows a workaround to compare two versions of Excel and also gives a link to a small application that can also compare but with a track changes format. 
 So I guess you could workaround, but there is no way Studio is going to be able to support this out of the box as Excel itself does not support tracked changes in the same way Word does. Might be interesting to look at these other products though and see whether something could be done to generate a target file through a custom batch task using the API that could use one of these methods in some way. 
 Interesting topic. 
 Regards 
 Paul

Paul · Answer

Tyke said: The problem that I have is that I don't have an Excel sheet with my (tracked) changes, as they disappear when saving target as. 
 Of course they do... Excel out of the box does not support tracked changes in this way. 
 Regards 
 Paul

Trados Studio > 1. Trados Studio

Show tracked changes in target file.