Excel Import Issue since upgrading to Flexsim 2022 Update 1

Question

question

Jarod P asked Oct 11 2022 at 7:56 PM Jarod P commented Oct 12 2022 at 6:06 PM

Excel Import Issue since upgrading to Flexsim 2022 Update 1

Ever since i have updated to FlexSim 2022.1.0 i have been having an issue importing excel files into global tables. I thought perhaps it was an issue with .1.0 so i installed .2.0 but am having the same issue. I have encountered it on models that were very large so i chalked it up to me making some mistake in the model so i worked around it on that model. Today i started creating a brand new model, i dont even have a Process Flow started and im getting this error. U71x Spoiler.fsm

Software Version:

FlexSim 22.2.1

excel import import 2022

1665517922422.png (62.0 KiB)

u71x-spoiler.fsm (296.9 KiB)

· 6

Ben Wilson ♦♦ commented · Oct 12 2022 at 11:51 AM

@Jarod P do you still have an older version of FlexSim installed that you could test? My hunch is that the issue may actually be on the Windows/Excel side, and you'd find the issue even in an older version of FlexSim where you know your Excel import had previously worked.

Many of our users encounter Excel issues after Office updates. From Phil's answer:

"The problem is an issue with how Excel is registered as a COM application with Windows. It is usually fixed by uninstalling and reinstalling Excel."

In his answer Phil goes into the details about how these issues stem from Microsoft code out of our control. Luckily, as Phil mentions, many of our users are able to clear up Excel launch issues with a simple uninstall/reinstall of Office. My answer here links to resources for a deep uninstall of Office, if that is necessary.

0 ·

Jarod P Ben Wilson ♦♦ commented · Oct 12 2022 at 12:18 PM

2022.0.0 is the oldest version i have on my computer at this time, when i updated to it i cleared out all the previous versions. I will get with my IT to have the excel reinstalled.

0 ·

Jason Lightfoot ♦♦ Jarod P commented · Oct 12 2022 at 1:40 PM

You could also try an Office repair to see if that helps.

0 ·

Show more comments

Answer 1 · 2022-10-11T21:37:19Z

Jeanette F answered Oct 11 2022 at 9:37 PM Jarod P commented Oct 12 2022 at 6:06 PM

Hello @Jarod P,

I created a test excel file to load into your Global Table and it had no problems loading it in.

Could you send in an excel file that has this issue occur? From what I could find from past posts there was an occurrence when this error was thrown it did turn out to be a bug. However often with excel issues, repairing or reinstalling excel has solved issues. If you could send us a file that has issues we could more easily analyze if its a bug in FlexSim or if your excel is in need of repair.

· 3

Jarod P commented · Oct 12 2022 at 11:49 AM

71x Spoiler Schedule.xlsx

This is the sheet I had been trying to upload.

0 ·

71x-spoiler-schedule.xlsx (39.5 KiB)

Jeanette F ♦♦ Jarod P commented · Oct 12 2022 at 4:15 PM

Hello @Jarod P,

I never had an error throw. I was able to load sheet2 with no issues. However I did have trouble with Sheet1. The fix was to put a name in the first row and column that was originally blank.

I don't know if this will be a fix for you considering I never did see the error. Can you let us know if the problem persists?

0 ·

Jarod P Jeanette F ♦♦ commented · Oct 12 2022 at 6:06 PM

I added info to the A1 placeholder and it imported just fine as well.

0 ·

question