To preface, I am running simulations that have multiple states. Each state is exported into its own workbook. The data from all of the state workbooks is compared in a separate excel file that references each workbook. The simulation software does not do an internal comparison so I have to go through this process every time I change anything in my model.
When I update my simulation and rerun all of the states I export the new results to, for example, State1-1.exe, delete the old state file (State1.exe) then rename the new state file to State1.exe. The comparison workbook’s cells do not update until the new State1.exe is opened.
Is there any way or maybe a different method to go about this data comparison to have the comparison file update as soon as the new state workbook is renamed to the old workbook?
