I have a table which has columns for data input and others for calculations.
When I right-click and select the 'Insert / Table Rows Above' option, a row is inserted and some of the formulas are copied correctly but some are not.
in the attached file Row 15 was inserted with these results:
Column C has no formula
Column D has the correct formula
Column E has a formula when it shouldn't
Column F has a formula that's almost correct, the absolute reference row was changed when it shouldn't have been.
Column G has the correct formula
Any ideas on why it's not working and how to fix it?
Bookmarks