Example of what i want: If in cell A3 I have the formula =A1+A2, and if i copy that to another sheet, cell A3, the pasted formula will be exactly "=A1+A2", and it will refer to the cells A1 and A2 in the destination sheet. The formulas are not changed to be hard-coded to refer back to the cells in the source sheet for the copy operation.
But, apparently, in table language (I seem to have discovered), if you do a paste, a reference to the source table is inserted.
So, if a table has the following formula:
=F2+[@TiElMinAdj]
and if i copy that formula and then paste it into another table, a reference to the source table name appears to be inserted into the formula (in this case Table13 is the source table not the destination table). Here is the result of the paste.
=F2+Table13[@TiElMinAdj]
Is there any way to eliminate this undesirable behavior with table formulas, so that these paste just like other worksheet formulas, and that they refer to references in their new, destination sheet/table, and do not refer back to the source sheet from which they were copied?
Thanks!
But, apparently, in table language (I seem to have discovered), if you do a paste, a reference to the source table is inserted.
So, if a table has the following formula:
=F2+[@TiElMinAdj]
and if i copy that formula and then paste it into another table, a reference to the source table name appears to be inserted into the formula (in this case Table13 is the source table not the destination table). Here is the result of the paste.
=F2+Table13[@TiElMinAdj]
Is there any way to eliminate this undesirable behavior with table formulas, so that these paste just like other worksheet formulas, and that they refer to references in their new, destination sheet/table, and do not refer back to the source sheet from which they were copied?
Thanks!
