Tabel doesn't copy formula in two rows when expanded

[Daugaard92]

Hello everyone.

I have an Excel-sheet with a table, in which, I weekly insert new data and thereby expand the table.
A minor issue has annoyed me however; I have some prewritten formulas in many of the columns in the table and once I insert new data in empty columns within the table, calculations are automatically made, as the existing formulas are automatically pasted to the expanded rows. But two of my columns, doesn't automatically copy the existing formula to expanded rows.

It's difficult to explain in words, so I've included an image below. Imagine that the cells in the picture below were previously empty. Now, after i insert only "Renegotiation" and "Additional sale" in the cells to the left and thereby expand my table, formulas from the table are automatically pasted and calculated for most of the cells, as a value of "0" is then calculated (This happens when a table expands). But the selected "empy" cell and column, doesn't for some reason automatically paste the existing formula like the other cells, although it is written. - And i cannot understand why this happens?

I hope this makes sense and someone knows how I can fix this issue.

 

[mart37]

Is your table made with FORMAT AS TABLE?

 

[Daugaard92]

That's why it's weird, because I have - And it does automatically copy most of the formulas, but it excludes a few and I cannot figure out why.

 

[Fluff]

That sounds as though the formula in that column is not consistent.

 

[Daugaard92]

That sounds as though the formula in that column is not consistent.

Apparently there must have been a discrepancy somewhere; I copy/pasted the formula in the whole column and now it works flawlessly! Thanks!

 

[Fluff]

Glad we could help & thanks for the feedback.