Is there any way to copy relative references with table formulas.

TomCon

Board Regular
Joined
Mar 31, 2011
Messages
235
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!
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,372
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
If you copy the formula from the formula bar rather than copying a cell, it will paste as an identical formula.
 

Forum statistics

Threads
1,082,504
Messages
5,365,951
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top