Excel imports every time I reset the model

Question

question

Pinakin K asked Sep 25, '18 Sam Stubbs commented Sep 26, '18

Excel imports every time I reset the model

I have an excel import setup in my model. I have checked the option of importing excel on reset. But it should only occur when the excel workbook is changed or edited. in my case, i did not change it or update it. Still every time i reset the model, the excel is imported.

Note: the excel is not updated automatically, not any data is written to it.

The excel sheet location is in the same folder of the model itself.

please advice? Is there something missing?

Software Version:

FlexSim 18.1.2

excel import importing data from excel file to source excel importing

· 1

Sam Stubbs ♦ commented · Sep 26, 2018 at 04:27 PM

I'm not sure, do you have excel open running in the back ground? Could we have a copy of the model and excel file (or a dummy version of either for testing purposes) so we can replicate the issue?

1 ·

Answer 1 · 2018-09-26T17:14:45Z

Pinakin K answered Sep 26, '18 Sam Stubbs commented Sep 26, '18

I resolved the issue by copying the file to my local computer instead of on the cloud.

So when my excel file was on cloud, it used to get synced often. This caused the file to import every time I press reset.

However, when I have to put my model and the files on the cloud this issue would rise again.

· 1

Sam Stubbs ♦ commented · Sep 26, 2018 at 05:19 PM

Yeah, unfortunately I don't know if there's anything to do for that issue. Since FlexSim checks if the file has been updated since the last time it imported, and a cloud sync would cause the file to show as having been updated.

1 ·

question