When I translate an excel file with SDL Studio, and Save Target As, the excell file now has many number cells turn to #REF! or #VALUE! instead of the actual number. Thousands of such cells, so impossible to correct manually. What do I do?!!!
Help, please.
Vytautas
Well... I think you need to do this.
If you don't have the source then perhaps this is simply because it's a formula looking up information in another sheet that you don't have... or something like this.
Paul Filkin | RWS
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
I checked one cell. The original cell says "=SUM(D22:D24)".The translated target says "=SUM(D22:D24)". Seems the same. But the cell in the translated target shows "#REF!", while instead it should be "864 901"
So, what's in cells D22 - D24?
Paul Filkin | RWS
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
The reason I ask is because these are Excel errors. So its likely that there is a formula in there that is looking for some hardcoded value that you have now translated. So it can't find the value.
So your task, if it's down to you, is to trace the location of this formula and fix the problem. Or at least point out to your customer what the problem is so they can fix it.
Paul Filkin | RWS
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
The reason I ask is because these are Excel errors. So its likely that there is a formula in there that is looking for some hardcoded value that you have now translated. So it can't find the value.
So your task, if it's down to you, is to trace the location of this formula and fix the problem. Or at least point out to your customer what the problem is so they can fix it.
Paul Filkin | RWS
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
Translate
