When I export data into excel, I try to use another sheet to get values and format data.
When data are updated by EasyMorph, others sheets are not updated.
EasyMorph create random values and export them to Excel.
Data are updated each time in Excel in sheet “Data”.
But value in sheet “Formula” are not updated.
Options to run calcul don’t make anything. I must go into each cells and validate formula to update value manually.
Why does Excel file not update after updating data by EasyMorph?
Thanks in advance for your help.