Forum Discussion
Pasting structured references results in link instead of normal formula
If I copy cells from a table in workbookA then paste into another table in workbookB, any formulas with structured references will remain linked to the table in workbookA. However, I want the struct...
I don't know if this is the answer, but it'd be the first thing I'd try. That would be to use Paste Special...Formulas
You could also (though it may just be a "manual version" of the above) try to copy the formula from the formula bar rather than from the cell in which it appears.
I tried all the options in paste special, nothing changed the outcome. It seems to default to the "Paste Link" option and no way to paste anything but that.
Copying and pasting the text of the formula is a valid workaround, but if I'm copying and pasting a lot of cells, this isn't a viable option. Another option is to create a script, BUT I'm looking for something compatible with normal copy/paste first.
Copying and pasting the text of the formula is a valid workaround, but if I'm copying and pasting a lot of cells, this isn't a viable option. Another option is to create a script, BUT I'm looking for something compatible with normal copy/paste first.