No internet connection
  1. Home
  2. Questions

Recalculate an excel file to update formulas/values

By isedwinr @isedwinr
    2022-11-22 10:09:40.406Z


    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?


    Solved in post #2, click to view
    • 1 replies
    1. I
      isedwinr @isedwinr
        2022-11-24 07:33:24.631Z

        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." *