Error while importing excel data

Question

question

elizabeth.l asked Oct 4, '17 elizabeth.l answered Oct 5, '17

Error while importing excel data

What does this message signify? "Error updating cached Excel Data". After I press OK, I get "Sheet name does not exist in file" I know it's not actually a problem with the sheet name because if I delete enough columns eventually the import starts working. Unfortunately, I can't share the excel file.

Software Version:

FlexSim 17.0.7

excel import

· 1

Jeff Nordgren commented · Oct 04, 2017 at 11:58 PM

@elizabeth.lopez

Can you create an Excel file that does the same thing with "bogus" information in it? And send us that one? Or give us more specific information on the Excel file and then send us your model in another question, marked "Private". That way only FlexSim employees, who are under NDAs, would be able to view it.

Thanks.

0 ·

Answer 1 · 2017-10-05T14:20:55Z

elizabeth.l answered Oct 5, '17

So I tried quite a few things trying to narrow down the problem. I was unable to recreate the error with a fresh excel document with dummy data. I noticed that the file was bigger that I thought it should be. I goggled the potential reasons for this and found it could be the formatting.

I cleared the formatting from the empty cells of the sheet and just like that, the file size decreased dramatically and the import started to work.

question