Microsoft Word Template doesn't refresh table formulas

[stalworx]

I’m trying to build a PDF invoice based off a webhook call that sends data to a Microsoft Word Template I’m storing in Sharepoint.

I have the webhook successfully populating data into the Microsoft Word Template but when I open the docx file or PDF, the lines that run off table formulas don’t update properly.

Does anyone know a way using Make to update the formula results? I know if this was on desktop Word, you would need to manually select the fields to update them.

[samliew]

Welcome to the Make community!

From what I can find online, it looks like this isn’t possible without code, because for Word to update a field automatically, you need to write some code to set the cell/field as “dirty”, because there is no user input that triggers this change.

For more information, see

• java - How to compute =SUM(Above) function in docx using apache poi - Stack Overflow
• java - SUM(ABOVE) functionality in apache poi or docx4j - Stack Overflow

[stalworx]

Okay, thank you for the response!