Unable to import from Excel

Question

question

Jeremy R asked Dec 18, '18 Phil BoBo commented Dec 2, '19

Unable to import from Excel

Until recently, I was able to import data from Excel into my model using the "Excel Import/Export Interface". However, now whenever I try to import from Excel, I get the Excel interface error "Failed to initialize Excel Application! Error code -2147221005". Clicking "Okay" brings up the pop-up "The Excel file did not open correctly. Do you want to browse for the file?"

error-message.png

error-message-2.png

Notably, my Excel was recently updated to Version 1811. However, my co-workers also have the same version of Excel and have no issue importing from Excel into the same model. Additionally, this issue appears to be affecting my ability to import into any FlexSim model (even an empty one I just created), not just the model I have been working on.

I have attached images of the error messages.

Software Version:

FlexSim 18.2.0

excel import excel

error-message.png (3.0 KiB)

error-message-2.png (3.0 KiB)

· 7

Joshua S commented · Dec 19, 2018 at 07:37 PM

This might be a registry issue since it's localized to your machine. Try reinstalling Flexsim, and if that doesn't work try reinstalling Office as well.

0 ·

Omar Aguilera Rico commented · Nov 26, 2019 at 10:05 PM

Hi @Joshua S ! I have the same problem. Uninstall and install Office and test if it works but not. Uninstall FlexSim 19.2.4 and reinstall but it still presents me with the same problem when I want to import information from Excel. How can I solve this problem?

0 ·

screenshot-1.png (61.5 KiB)

Joshua S Omar Aguilera Rico commented · Nov 26, 2019 at 10:14 PM

@Omar Aguilera Rico

Have you had multiple versions of Excel on your computer? I noticed I had to clean up bread crumbs that Office leaves behind after installing an uninstalling different versions, especially if there were multiple versions of excel installed on the same computer.

0 ·

Omar Aguilera Rico Joshua S commented · Nov 26, 2019 at 10:21 PM

@Joshua S

I have a new computer equipment. I have only installed the latest version of Excel. The Office 365 package.

0 ·

Show more comments

Answer 1 · 2019-01-01T22:29:51Z

Jeremy R answered Jan 1, '19

Reinstalling Excel seemed to fix this issue. I don't really understand why the issue originally occurred or what reinstalling Excel fixed, but that appears to be the solution here.

question