I'm using the "Update Excel File" action to add csv values to different tabs in an EXCEL.
A totals report sheet in this file shows the totals plus a graph
I then want to generate a PDF of this sheet (via "Convert Document"), but that is not possible because the various formulas of the Report-Sheet have not yet been updated.
So if I (manually) open the sheet in between, save and close it again, it works fine.
Anyone an idea how I can solve this? with a PowerShell command or something?
- 1 replies
- Iisedwinr @isedwinr
Even faster than a girl untagging herself from a photo that makes her look fat!
Solved in the Pre-release, thank you!
*"Improvement: Added Recalculate option to Update Excel File action. This option will ensure all formulas are recalculated after the update." *ReplySolution