Tag Editor Error "The worksheet name uses imported data from an external source..."
Thread poster: LSGTranslations

LSGTranslations  Identity Verified
Argentina
Member (2010)
English to Spanish
+ ...
Oct 19, 2010

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.


 

Jerzy Czopik  Identity Verified
Germany
Local time: 13:03
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  Identity Verified
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  Identity Verified
Germany
Local time: 13:03
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  Identity Verified
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!

 

Fernando Williams
Argentina
Local time: 08:03
English to Spanish
¡Gracias! Apr 14, 2011

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: 13:03
Dutch to German
Thank you Jul 16, 2011

1000 karma-points for Jerzy!

 

Louise Taggart  Identity Verified
United Kingdom
Local time: 12:03
Member (2008)
German to English
Thank you! Oct 12, 2011

I also just had this problem ... and your posting here has helped me tremendously.
Many thanks


 

Lorena Vicente  Identity Verified
Argentina
Local time: 08:03
Member (2005)
English to Spanish
+ ...
Thanks Mar 17, 2012

Thank you, Jerzy!

I had the same problem today and was able to solve thanks to your suggestion.

Best,

Lorena


 

Meritxell Ripollès  Identity Verified
Spain
Local time: 13:03
Bulgarian to Spanish
+ ...
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 timeicon_smile.gif

 

Stacy Macaulay
Germany
Local time: 13:03
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 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


 


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..."

Advanced search







Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search