Hello all,

I've got a number of Excel tables which each have the same exact column headers. I've built a formula in one table that I need to use in every other table. However when I paste the formula from one table to another table the formula brings over not just the header name, but also the table name, which makes the formula unusable in the other tables. At present I go through and delete the table reference each time I paste it, but I wanted to see if there was a way to paste formula only and exclude the table name.

Does anyone know if this is possible?


example:
This is a (simplified) example of how the formula looks in the original table

=[@ARV]+[@contributions]

But when I paste it in to another table this is what it does:

=Table1[@ARV]+Table1[@contributions]

Any way to copy the formula without the "Table1" portion?