Write to Excel Template not updating specific cells with formula
Hello, I am using Write to Excel Template node and in my template, there is already a formula.
So when I run the workflow, the formula is not updating because the excel is not reading data pasted from write to excel template node. As you can see in the screenshot, the formula is just sum the 2115 and 9, but still showing 0 as total.
To fix it, I really need to manually click the cell with formula and hit F2 + Enter to recalculate the formula.
Though in write to excel template, the recalculate box is already ticked.