Error message Failed to save target file - object reference not set to an instance of an object - Excel file

Question

I have tried 
 1 - changing the order of the worksheets in the Excel file 
 2 - using Studio 2014 
 3 - saving source Excel file in an .xls format 
 but to no avail. I cannot produce a target file and my client is expecting this shortly. 
 Does someone have other ideas? 
 
 Thanks 
 Carole

Paul Filkin · Answer

Hi Carole Choquette , 
 
To troubleshoot files try this article: 
 
How to troubleshoot problematic files : gateway.sdl.com/.../communityknowledge 
 
More often, the solution to these problems is resolved like this: 
 
- Open the source file again using the "Translate Single Document" process 
- Save it to create a single file project 
- Try to save target now before you do anything. 
- If it works go onto the next step, but if it doesn't then you need to consider the more advanced trouble shooting steps in the KB article 
- Pretranslate the file using your Translation Memory 
- Save the target file 
 
If none of that helps, and if you are allowed to share the file you can send me the fully translated sdlxliff and the original source file and I'll happily take a look. 
 
Regards 
 
Paul 
pfilkin@sdl.com

Trados Studio > 1. Trados Studio

Error message Failed to save target file - object reference not set to an instance of an object - Excel file