Tag Editor Error "The worksheet name uses imported data from an external source..." Thread poster: 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 
Germany
Local time: 11:26
Member (2003)
Polish to 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.
| | | | LSGTranslations
Argentina
Member (2010)
English to Spanish
+ ...
TOPIC STARTER | 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
Germany
Local time: 11:26
Member (2003)
Polish to 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.
| | |
|
|
|
LSGTranslations
Argentina
Member (2010)
English to Spanish
+ ...
TOPIC STARTER | 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!
| | | | Malte Wendt
Netherlands
Local time: 11:26
Dutch to German
1000 karma-points for Jerzy!
| | | | Louise Taggart
United Kingdom
Local time: 10:26
German to English
+ ...
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
Germany
Local time: 11:26
Member (2005)
German to 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..." | Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
More info » |
| | CafeTran Espresso | You've never met a CAT tool this clever!
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
Buy now! » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
Translation news related to SDL Trados
