About EasyMorph Tutorials & Examples Web-help

Export to Excel doesn't refresh formulas linked

Hello,

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.

Example:
EasyMorph create random values and export them to Excel.
image

Data are updated each time in Excel in sheet “Data”.
image

But value in sheet “Formula” are not updated.
image

Options to run calcul don’t make anything. I must go into each cells and validate formula to update value manually.
image

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.

Hello,

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
$excel.CalculateFull()
# Refreshes all external data ranges and PivotTable reports
$workbook.RefreshAll()
$workbook.close($true)
$excel.quit()

It’s work.

Thanks

To learn more about EasyMorph visit easymorph.com.