question

Raashid Mohammed avatar image
0 Likes"
Raashid Mohammed asked Phil BoBo answered

How to refresh excel data from flexsim before import

Hi

I have a Excel file with data connections.

Before importing the data from excel to flexsim. I want to refresh excel tables to get new data then do the flexsim import

Thanks

Raashid

FlexSim 17.0.1
excel import
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.

2 Answers

Jeff Nordgren avatar image
0 Likes"
Jeff Nordgren answered Raashid Mohammed commented

@Raashid Mohammed,

Unless I'm not understanding what you are after, all you have to do is refresh the Excel spreadsheet and then do the Excel Import from FlexSim. That should bring in the new information. Is there something I'm missing in your description?

· 1
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.

Raashid Mohammed avatar image Raashid Mohammed commented ·

Hi @Jeff Nordgren

I would like to refresh excel directly from Flexsim without opening excel

I dont want to open the excel just to refresh then open flexsim to do import

Trying to limit the end user to just open the flexsim model and the flexsim itself refresh the excel in the background before import

Thanks

Raashid

0 Likes 0 ·
Phil BoBo avatar image
1 Like"
Phil BoBo answered

Maybe try Automatically refresh data when a workbook is opened [https://support.office.com]

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.