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

Local time: 08:40
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!

Direct link Reply with quote

Local time: 08:40
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?

Direct link Reply with quote

Nick Quaintmere  Identity Verified
Local time: 07:40
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.

Direct link Reply with quote

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

Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for users! Save over 13% when purchasing Wordfast Pro through Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

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