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...
What you've described sounds very much like an ideal application for the template solution I alluded to in my last reply. Here is a link to a page with several resources that might help understanding how, instead of copying from your workbook A to workbook B, you create a basic version and save it as a template, from which you more easily create B without copying and pasting.
I don't know how to share documents here.
If the template references don't fit your need, then perhaps you can post a copy of the sheet you're working with on OneDrive or GoogleDrive and paste a link here that grants edit access to that sheet.
How about you create a second table that uses the data from the first and adds the formulas (i.e. make the table you are copying have only data and no formulas)