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
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 Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Hi Paul,
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.
Here's a target segment with the tracked changes:
and this is what it looks like in the save target as Excel file:
Just like Rose, I couldn't get the add-on to work either, which doesn't really matter as it would not be any help.
I tried copying the column from review changes docx file into an Excel sheet, but it shows all the tags and not the coloured underlined/strike through text, so that didn't help either. It could well be if I could get the track changes like text into review changes I could could then copy them into Excel. Any ideas?
It looks like it is going to be the long slog.
All the best.
Ben
Hi Paul,
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.
Here's a target segment with the tracked changes:
and this is what it looks like in the save target as Excel file:
Just like Rose, I couldn't get the add-on to work either, which doesn't really matter as it would not be any help.
I tried copying the column from review changes docx file into an Excel sheet, but it shows all the tags and not the coloured underlined/strike through text, so that didn't help either. It could well be if I could get the track changes like text into review changes I could could then copy them into Excel. Any ideas?
It looks like it is going to be the long slog.
All the best.
Ben
Hi Paul,
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.
Here's a target segment with the tracked changes:
and this is what it looks like in the save target as Excel file:
Just like Rose, I couldn't get the add-on to work either, which doesn't really matter as it would not be any help.
I tried copying the column from review changes docx file into an Excel sheet, but it shows all the tags and not the coloured underlined/strike through text, so that didn't help either. It could well be if I could get the track changes like text into review changes I could could then copy them into Excel. Any ideas?
It looks like it is going to be the long slog.
All the best.
Ben
Translate
