Aggregate Formula Not Automatically Calculating When Written To Results Spreadsheet

I have a python 3.7 script that has been developed using the OPENPYXL (v2.5.10) library to take data from a number of excel workbooks, to process that data and then to write to a s

Solution 1:

All - the final answer for completeness.

It turns out that the key to solving this issue lay with OPENPYXL and that the guidance provided in the answer by Charlie Clark to this

question

was correct. I had initially applied the solution incorrectly.

I changed the formula to:

activeSheet.cell(row, col).value = \ f"=IFERROR(INDEX({rngData}, _xlfn.AGGREGATE(15,3,({rng}={cellRef})/({rng}={cellRef})*ROW({rng}),{nth}),{colIndex}),\"\")"

by adding in the '_xlfn.' to the front of the AGGREGATE function statement.

The excel spreadsheet now works as expected without the need to edit the cell containing the formula.