question

Jeremy R avatar image
0 Likes"
Jeremy R asked Phil BoBo commented

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.

FlexSim 18.2.0
excel importexcel
error-message.png (3.0 KiB)
error-message-2.png (3.0 KiB)
· 7
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Joshua S avatar image Joshua S commented ·

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 Likes 0 ·
Omar Aguilera Rico avatar image Omar Aguilera Rico commented ·

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 Likes 0 ·
screenshot-1.png (61.5 KiB)
Joshua S avatar image Joshua S Omar Aguilera Rico commented ·

@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 Likes 0 ·
Omar Aguilera Rico avatar image Omar Aguilera Rico Joshua S commented ·
@Joshua S

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

0 Likes 0 ·
Show more comments
Show more comments

1 Answer

Jeremy R avatar image
0 Likes"
Jeremy R answered

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.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.