Trados Studio 2009 SP3, xlsx, Error: "Object rerence not set to instance of object"
Thread poster: Bartek Zukowski

Bartek Zukowski
Local time: 15:42
English to Polish
+ ...
Apr 18, 2011


again I have a critical problem with SDL Trados Studio 2009 SP3 (with all updates available through "Check for updates" option in application menu).

I have a couple of translated xlsx files and when trying to generate target translations I get error saying "object reference not set to instance of object" (but in Polish since my OS is Polish).For each file I get two error messages:
- one with origin: "Sdl.FileTypeSupport.Framework.Adapter.Framework1.Writer"
- and the second one: "Generate Target Translations"
Each of these files contains one worksheet with one column with text.

Any idea what is causing this error and how to avoid it?

Without possibility to create target translations Trados becomes completely unusable :-/

In our previous projects I always have converted xlsx files to txt, because Trados seems to be working fairly well with this basic file format. After creating target translation I only needed to paste the contents of txt files back into the source xlsx. This time it was impossible, because contents of the files got messed up during convert->convert->paste process.

Below you can check error details:

<SDLErrorDetails time="2011-04-18 09:59:36">
<ErrorMessage>Odwołanie do obiektu nie zostało ustawione na wystąpienie obiektu.</ErrorMessage>
<Type>Sdl.FileTypeSupport.Framework.FileTypeSupportException, Sdl.FileTypeSupport.Framework.Core, Version=, Culture=neutral, PublicKeyToken=c28cdb26c445c888</Type>
<HelpLink />
<StackTrace><![CDATA[ w Sdl.FileTypeSupport.Framework.Adapter.Framework1.AbstractFramework1Adapter.ReThrowFilterFramework1Exception(Exception* x)
w Sdl.FileTypeSupport.Framework.Adapter.Framework1.Writer.EndOfInput()
w Sdl.FileTypeSupport.Framework.Integration.NativeWriterMessagesProxy.EndOfInput()
w Sdl.FileTypeSupport.Framework.Integration.FileGenerator.CallEndOfInput()
w Sdl.FileTypeSupport.Framework.Integration.FileGenerator.FileComplete()
w Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
w Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.FileComplete()
w Sdl.FileTypeSupport.Framework.BilingualApi.AbstractBilingualContentProcessor.FileComplete()
w Sdl.FileTypeSupport.Framework.Integration.AbstractBilingualProcessorContainer.FileComplete()
w Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.ContinueParsing()
w Sdl.FileTypeSupport.Bilingual.SdlXliff.XliffFileReader.ParseNext()
w Sdl.FileTypeSupport.Framework.Integration.FileExtractor.ParseNext()
w Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.ParseNext()
w Sdl.FileTypeSupport.Framework.Integration.MultiFileConverter.Parse()
w Sdl.ProjectApi.AutomaticTasks.GenerateTargetTranslation.NativeFileGenerator.GenerateFiles()
w Sdl.ProjectApi.AutomaticTasks.GenerateTargetTranslation.GenerateTargetTranslationTask.ProcessFile(IExecutingTaskFile executingTaskFile)
w Sdl.ProjectApi.AutomaticTasks.AbstractFileLevelAutomaticTaskImplementation.Execute()]]></StackTrace>
<ProductName>SDL Trados Studio</ProductName>
<OperatingSystem>Microsoft Windows 7 Ultimate </OperatingSystem>
<ServicePack>Service Pack 1</ServicePack>
<PhysicalMemory>4193328 MB</PhysicalMemory>


Bartek Zukowski
Local time: 15:42
English to Polish
+ ...
disappointed Apr 27, 2011

So it seems that again this expensive piece of software can't even perform its basic functions and nobody knows why... nice :-/


Michael Watson  Identity Verified
United Kingdom
Local time: 14:42
Member (2006)
German to English
+ ...
short term workaround May 13, 2011

I too have had this message.

As an inconvenient workaround you can right-click the translation units and change the translation status to translated. (You can also apply this to a batch of translation units). You can then move through the document using ctrl+down arrow and periodically update the translation status of translated units.

Still a pain in the derriere through!


Marcel Hlbočan
Local time: 15:42
Slovak to English
+ ...
Any solutions yet? Jul 6, 2011

Same problem here.
I went through all suggestions published in this forum but to no avail. This is what I tried so far:

0. Suggestion to upgrade to SP2/3 does not apply to me.

1. I checked the Worksheet names - they are all left unchanged.

2. I have deleted Trados configuration files as suggested by Trados support, or even renamed entire SDL folders to xxxx_old. Trados did generate new config folders/files, but the error remained the same.

3. I tried to save the file in xlxs format - without macros, translated this file, but when generating target translation, I had the same error again.

4. I tried to save the file in xls format - the same error again.

5. I switched off tag verification completely and used the "skip worksheet name" option - the same error again.

If anyone can think of anything else I could do, please help. Thank you in advance.



Local time: 15:42
English to Spanish
+ ...
Looking for a solution urgently Jul 12, 2012

Exact same situation here as described in the last post and I'm on a deadline (nothing unusual I suppose).
Any progress on this situation?


To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Trados Studio 2009 SP3, xlsx, Error: "Object rerence not set to instance of object"

Advanced search

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 »
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 »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search