I have a sheet like below. I want to copy all formulas from workbook B into A but without the reference to workbook B.
when I do it now I currently get a link in all my formulas to workbook B. But I want just the formulas but linked to my current workbook (workbook a)
If I copy a basic sum formula it works but when the formula involves a table, the reference is to workbook B.
here is a sample formula,
=IF(Start!$D$8="Weekly",0.000001*SUMIFS(tbl_database[Value],tbl_database[Node],H$2,tbl_database[Type],$A14,tbl_database[Accounting],$C$1,tbl_database[Filter],"No"),0.000001*SUMIFS(tbl_database[Value],tbl_database[Node],H$2,tbl_database[Type],$A14,tbl_database[Accounting],$C$1,tbl_database[Source],"<>stack",tbl_database[Source],"<>overflow"))
workbook A Sheet a:
workbook B sheet B
if I go to the formula bar and copy the actual formula from workbook B into A, I get the expected result, but as you can see with all these formulas, it can be tedious.
SUM
, but formulas from workbook B that reference a table, I get the reference to workbook B.