question

Durga Ghosal avatar image
0 Likes"
Durga Ghosal asked Phil BoBo edited

Excel export changes excel options

I am trying to export data, save and close excel using commands "excelsave" and "excelclose". Every time I do that it changes my excel options -> formulas -> calculation options from Automatic to Manual.

I am facing the same issue if I use FlexSim excel export GUI. I am using office 365, Excel 2016 64 bit.

Any suggestion would be helpful?

FlexSim 18.0.7
excel export
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.

1 Answer

Phil BoBo avatar image
1 Like"
Phil BoBo answered Phil BoBo edited

I was able to replicate the issue and figure out what was causing it. I have fixed the issue for the next bugfix release.

To fix it in the meantime, you can execute the following script any time before calling excelclose(1):

maintenance(48, 1);

That will set a flag that will cause the excelclose(1) command to set the workbook back to Automatic.

Also, in case you are interested: the Workbook Calculation setting in Excel is based on the setting of the first workbook you open in a session of Excel; it isn't actually a global setting in Excel. So if you open Excel, start a blank workbook, and then open the Excel file exported from FlexSim, the setting will be Automatic instead of Manual.

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.