I converted a range of rows and columns with a few columns contains formulas into a table. After doing so adding a new row to the tables does not automatically extend the formula to the new row. I tried selecting the table and using refresh all, made sure the table is with header row on, tried apply computation etc to no avail. Please can someone help with how to get this working. Or do I need to rewrite the formulas with reference to table name, column name. That would be a lot of work.
This will happen when you do not have the same formula in every cell above the new row. If a cell has a value, text or a different formula, it won't copy down.
To fix it, re-enter the formula in the first cell of the column and copy down to ensure they're all the same.
Yes that was the issue. Making sure the formulas are the same across all the rows in the column before creating the table, solved the issue. Thanks a lot
