i spreadsheet have 12 tables. build copies of first one.
in table have lot of formulas,e.g.
=round([@[købspris pr stk]]/(100-[@[dg pr stk]])*100;2) when insert new rows, ctrl + or others, new row should hold copy of actual row.
instead formula in new row is:
=round(kalkulationdkk1[@[købspris pr stk]]/(100-kalkulationdkk1[@[dg pr stk]])*100;2) "kalkulationdkk1" table name of original table.
i can't see why, , can't fix it.
any ideas?
when using tables, excel default structured references instead of relative references. here suggestions can do:
- edit formulas after copying them, , manually remove table name.
- edit formulas use relative references instead of structured references before copying them.
- combine 12 tables 1 table, using column distinguish between them
- do not use tables. references relative , copy behaves expect.
