...
- If a formula references cells above all data marker rows, ExcelWriter will not move or modify it.
- * If a formula references cells below a data marker row, the references will be updated if new rows are inserted between the data marker row and the cells referenced in the formula.
* - If a formula references a data marker cell, the formula will be "stretched" to include the imported cell values.
\
Example
In the ExcelWriter template, cell A11 contains the formula =SUM(A9:A9).
...