Can't open XLSM: index was out of range
Thread poster: blender_kid

Local time: 11:27
Russian to English
Jul 25, 2013

I have a problem with opening an excel sheet with macros (.xlsm) in Studio 2011.
I can't even save it into sdlxliff.

The error message is "Index was out of range. Must be non-negative and less than the size of the collection".

I remove all the protection from the file, but it didn't work.
I tried to change the format into .xlsx, but Studio returned the same error.

Any idea what could be the cause?

Thank you for any responses!


Local time: 11:27
Russian to English
drop-down lists Jul 25, 2013

The excel file has drop-down list boxes in each column.

Could that be the cause of the problem?


Nick Quaintmere  Identity Verified
Local time: 10:27
German to English
Try a restart Jul 25, 2013

I have had moments when Trados has gone crazy like this and sometimes a restart has solved the problem. By restart I mean closing all applications and restarting the computer.
Hopefully that will allow you to continue.


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

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

Can't open XLSM: index was out of range

Advanced search

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 »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »

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