Tag Editor Error "The worksheet name uses imported data from an external source..." 论题张贴者: LSGTranslations
|
|---|
Hello, everyone. I'm working on a huge project using Tag Editor to translate Excel sheets and when I finished translating a 20k word document and tried to save the target file, I got the following error: "The worksheet name uses imported data from an external source, therefore the sheet name cannot be changed for the following sheet: module 1". I'm no expert in TRADOS, but I asked around and nobody has been able to help me with this. I'm working with TRADOS 2007. Please help! Thanks in advance.<... See more Hello, everyone. I'm working on a huge project using Tag Editor to translate Excel sheets and when I finished translating a 20k word document and tried to save the target file, I got the following error: "The worksheet name uses imported data from an external source, therefore the sheet name cannot be changed for the following sheet: module 1". I'm no expert in TRADOS, but I asked around and nobody has been able to help me with this. I'm working with TRADOS 2007. Please help! Thanks in advance.
Hola a todos. Estoy trabajando en un proyecto enorme utilizando Tag Editor para traducir hojas Excel y cuando terminé de traducir un documento de 20.000 palabras e intenté guardar el archivo target, me salió el siguiente error: "The worksheet name uses imported data from an external source, therefore the sheet name cannot be changed for the following sheet: module 1". Yo no soy experta en TRADOS, pero pregunté a varias personas y nadie ha sido capaz de ayudarme con esto. Estoy trabajando con TRADOS 2007. ¡Ayuda por favor! Gracias de antemano. ▲ Collapse
| | | | Jerzy Czopik 
德国
Local time: 03:57
正式会员 (自2003)
Polish波兰语译成German德语
+ ...
| You are supposed NOT to translate worksheet names | Oct 19, 2010 |
Use the search function in Tageditor
Search in tags for "sheet".
This will show yiu the worksheet names - when you find such tag, open the segment withing this tag and restore source for it (this simply means: leave worksheet names untranslated).
Do this for all WS-names.
After that your Excel file should save properly.
| | | | | No segments found | Oct 19, 2010 |
Thanks for your comment. Unfortunately, I couldn't solve my problem with this. I went to Edit, find (on Tag Editor) and searched in tags for "sheet" and the only thing that came up where two tags in grey (no segments there) with the word "worksheet". That's all I got. Any ideas? Thanks anyways.
| | | | Jerzy Czopik
德国
Local time: 03:57
正式会员 (自2003)
Polish波兰语译成German德语
+ ...
| When you find the tag... | Oct 19, 2010 |
Press ALT+HOME, it will open the segment.
When you see tag with the name "Worksheet", it starts the worksheet name - please just restore the names, which begin as segment with the "Worksheet" tag.
| | |
|
|
|
| Problem solved! | Oct 19, 2010 |
You are a life saver! Thank you so much for your help!
| | | |
I had this very same problem today and I worked it out thanks to your instructions, Jerzy. Thank you so much and thanks Mara for posting such a useful question!
| | | |
1000 karma-points for Jerzy!
| | | |
I also just had this problem ... and your posting here has helped me tremendously.
Many thanks
| | |
|
|
|
Thank you, Jerzy!
I had the same problem today and was able to solve thanks to your suggestion.
Best,
Lorena
| | | | | Thanks a lot! | May 14, 2012 |
Thank you! I had the same problem and had no idea how to solve it. Thanks to your comments I managed to deliver my translation on time
| | | | Stacy Macaulay
德国
Local time: 03:57
正式会员 (自2005)
German德语译成English英语
+ ...
| Still unresolved | Jul 16, 2012 |
Hi there,
This is definitely a solid tip, but I seem to have a particularly difficult case on my hands right now with only hours until delivery of a huge file. I've read every single article out there on saving a TTX back to the original xlsx file, have tried everything and still have no idea why I keep getting the object reference message. The xlsx contains html code, but only in the cell text, which I am starting to suspect is the reason for this error. I have checked the sheet na... See more Hi there,
This is definitely a solid tip, but I seem to have a particularly difficult case on my hands right now with only hours until delivery of a huge file. I've read every single article out there on saving a TTX back to the original xlsx file, have tried everything and still have no idea why I keep getting the object reference message. The xlsx contains html code, but only in the cell text, which I am starting to suspect is the reason for this error. I have checked the sheet name and it was the same as the original, I even inserted it again to no avail though.
Of course, the original xlsx and the ttx are both in the same folder, I have also opened the TTX in notepad to verify that the original path is still there. I have definitely run out of options, due date in 6 hours and I leave on holidays an hour later!!!
I would sure appreciate some late night help on this one, it's a tough nut to crack this time.
Also, is there any way of salvaging the situation? I have a perfect TTX file, have also tried to clean the file with workbench with the same error message. Now my hands are tied and I'm pretty sure my client isn't going to be able to solve this situation either considering the utter complexity/the fact that it appears to be a unique case.
So if you have any enlightening thoughts I would more than grateful!
Thanks again,
Stace ▲ Collapse
| | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Tag Editor Error "The worksheet name uses imported data from an external source..." | TM-Town | Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.
More info » |
| | Wordfast Pro | Translation Memory Software for Any Platform
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value
Buy now! » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
Translation news related to SDL Trados
