question

elizabeth.l avatar image
0 Likes"
elizabeth.l asked elizabeth.l answered

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.

FlexSim 17.0.7
excel import
· 1
5 |100000

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

1 Answer

elizabeth.l avatar image
1 Like"
elizabeth.l answered

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.

5 |100000

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