Importing Excel files with "select ranges in Excel" fails
Thread poster: Vito Smolej

Vito Smolej
Germany
Local time: 03:24
Member (2004)
English to Slovenian
+ ...
Jan 6, 2016

On importing Excel files, I have been using extensively the feature in "Document import settings" that allows one to select ranges in the Excel. Since recently however the option "select ranges in Excel" returns with "Failed to open file" message box. This happens

i) for different Excel file extensions (xls, xlsx)
ii) for different (and all) excel files
iii) different filter (plain excel and excel for .... 2013) in the settings
iv) both for MemoQ 2014 R2 and 2015 (! - both performed correctly and as expected week or two ago)

The Office version used is office professional 2016, installed middle of December - saying MemoQ worked correctly already with this version (could of course be some silent upgrade, who th knows...)

remains only my (oh well, yes, I know, well, can we stick to the subject?) windows 10 OS as a possible source of "misunderstandings". I tried compatibility set-up for "as suggested" and for win7, without any effect.

Note that I can work around by typing in the range(s) (e.g. Sheet!B200:B255) but that sucks - I know and like the rationale for "Select ranges in Excel" - and miss it.

"When everything else fails" suggestion by Kilgray - "Deinstall MemoQ and reinstall it again" just does not make much sense in this situation.

Any suggestions?

TiA

smo

PS: no, the excel files are not R/O. And, no, I do not have them opened while doing the import.


Direct link Reply with quote
 

Andriy Yasharov  Identity Verified
Ukraine
Local time: 04:24
Member (2008)
English to Russian
+ ...
Multilingual delimited text filter Jan 6, 2016

Instead of Microsoft Excel 2007, 2010 and 2013 filter try using the multilingual delimited text filter selected from a drop-down list during import of an Excel file. Then press Change filter and configuration and select Columns tab. Then you can select which columns must be translated.

I use memoQ 7.8.116 and if I need to use Microsoft Excel 2007, 2010 and 2013 filter, the Select ranges in Excel option is there in Importable ranges and general options tab.


Direct link Reply with quote
 

Vito Smolej
Germany
Local time: 03:24
Member (2004)
English to Slovenian
+ ...
TOPIC STARTER
Practical workaround - Thx! Jan 7, 2016

As my excel files always have a column "translated", where I initially place the source text, the suggestion works nicely. THX!

I still - of course - would welcome suggestions, how to solve the problem of failing "select ranges in Excel" feature in ExCel filters.

Regards

smo


Direct link Reply with quote
 

Leopoldo Gurman
Argentina
Local time: 23:24
Member (2004)
English to Spanish
Check the files path Jul 15

Hi Vito,

I've run into the same problem you have and thought I'd post my solution (took a while to figure it out). The error message isn't very helpful but it describes the problem perfectly: memoQ can't open the file. Next time you encounter this issue, try moving the file to a location with a shorter path, it did the trick for me.

Leo


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 »

Importing Excel files with "select ranges in Excel" fails

Advanced search






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



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