Excel file will not load into MemoQ
Thread poster: Gail Bond

Gail Bond  Identity Verified
United Kingdom
Local time: 04:02
Member (2009)
French to English
Nov 28, 2010

I'm trying to open an Excel file in MemoQ. It's not a big file, only 127k, but it gets about half way through and then just stops. Any ideas?

Thanks


 

Tomás Cano Binder, BA, CT  Identity Verified
Spain
Local time: 05:02
Member (2005)
English to Spanish
+ ...
Have you checked... Nov 28, 2010

...whether you have Excel installed in your machine and what version it is? Remember that MemoQ requires that you have the same version of Excel installed as the version of the file you want to import.

If you have an older Excel in your machine and the Excel file you have received is of a newer version, you might want to try to save the file with your older Excel in the old Excel format (with a different name so that you don't lose anything), and try again.

I hope this helps!


 

Gail Bond  Identity Verified
United Kingdom
Local time: 04:02
Member (2009)
French to English
TOPIC STARTER
Tried saving as a different version... still no luck Nov 28, 2010

Hi Tomás,

I have Excel 2007 on my computer, and the file is Excel 97-2003. I didn't realise they had to match. So I have saved the file in Excel 2007, as a .xlsx file, but MemoQ doesn't seem to recognise this format. It asks me to change the import settings... I set an Excel filter, but the same things happens, it gets half way through then stops.

Not sure what else to do...


 

Frank van Thienen (X)  Identity Verified
Canada
Local time: 20:02
Dutch to English
create a new spreadsheet Nov 28, 2010

I have Excel 2007 on my computer, and the file is Excel 97-2003...


Hi Gail,

First, I believe that memoQ does not yet have a filter for .xlsx (2007+) Excel files, so you need to stick with the Excel 97 format.

If problems persist, and the spreadsheet isn't terribly complex, I would try to copy the information to a brand new spreadsheet, and import that.
If formatting and such makes it too complicated, then at least copy the worksheet(s) (i.e. Sheet 1, Sheet 2, etc) with information to a new spreadsheet.

I have frequently run into spreadsheets that appear to have "something" buried inside that causes problems. Copying the data may leave that problem behind.

HTH
Frankicon_smile.gif


 

Fernando Toledo  Identity Verified
Germany
Local time: 05:02
German to Spanish
Maybe Dec 3, 2010

Filters and/or macros inside the sheet?

Regards


 

Gail Bond  Identity Verified
United Kingdom
Local time: 04:02
Member (2009)
French to English
TOPIC STARTER
Fixed it... Dec 3, 2010

...it was the preview generation that was causing the problem, so I switched that off and it worked fine.

Thanks to everyone for your help and suggestions.


 


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


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

Excel file will not load into MemoQ

Advanced search






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features, ensures new

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search