Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I get an “Invalid variant operation” when I try to import an Excel .xls or .xlsx file. Is there a solution?

April 26, 2017Excel file import solution Try

0

Posted

I get an “Invalid variant operation” when I try to import an Excel .xls or .xlsx file. Is there a solution?

1 Answer

0

Posted

A. First download the latest modules and see if that solves the problem. Microsoft Excel must be on the computer in order to import. (Open Office will not work.) During import, Excel is loaded into memory invisible and sent instructions to open the file, and copy the data to the clipboard in text format so it can be accessed. On a few systems this does not work for unknown reasons. If you continue to have problems, save the file from Excel in CSV format and then import as CSV.