About EasyMorph Tutorials & Examples Web-help

Export to Excel doesn't refresh formulas linked


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?

test.morph (2,1 Ko)
test.xlsx (11,5 Ko)

Thanks in advance for your help.


You can try to use the PowerShell action with the following script to update your Excel workbooks:

$excel = new-object -comobject excel.application
$workbook = $excel.workbooks.open(“D:\Repos\easymorph\Tests\Test_Data\ExcelCommand\TestRecalculate.xlsx”)
# Forces a full calculation of the data in all open workbooks
# Refreshes all external data ranges and PivotTable reports

It’s work.


To learn more about EasyMorph visit easymorph.com.