I am having a lot of success using openxpyxl to do many operations. I have a table of dates, numbers and formulas that I insert a new row within the table and enter some easy data (date, name, amount) but I am having trouble with columns that have simple formulas like cell F7 would be ‘=F6+C7’. F8 would be ‘=F7+C8’ etc down the table. When I insert the new (empty) row in the middle of the table, the rows below the insertrow do not get updated with the correct indexed. For example F24 becomes ‘=F22+C23’ instead of incrementing to ‘=F23+C24’ like it would do if I used an excel ‘fill down’ in the spreadsheet. So I am looking for help getting this to work. I have tried many things shown here: