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

Bartek Zukowski
Local time: 10:02
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: 10:02
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: 09:02
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: 10:02
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: 10:02
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

Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »

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