How to copy and paste formulas from one workbook to another WITHOUT REFERENCING ORIGINAL WORKBOOK.

I had the need of copying a sheet full of formulas from one workbook to another. Unfortunately, the destination sheet was showing formulas with reference to the original workbook (using Paste Special -> Formulas).

Example:

Original formula: =IF('01 MONDAY'!L9>0,'01 MONDAY'!L9,IF('01 MONDAY'!J9>0,'01 MONDAY'!J9&"VL",IF('01 MONDAY'!K9>0,'01 MONDAY'!K9&"SL",0)))
Destination formula (referencing original workbook): =IF('[00 - Wages - TEMPLATE - MASTER.xlsx]01 MONDAY'!L9>0,'[00 - Wages - TEMPLATE - MASTER.xlsx]01 MONDAY'!L9,IF('[00 - Wages - TEMPLATE - MASTER.xlsx]01 MONDAY'!J9>0,'[00 - Wages - TEMPLATE - MASTER.xlsx]01 MONDAY'!J9&"VL",IF('[00 - Wages - TEMPLATE - MASTER.xlsx]01 MONDAY'!K9>0,'[00 - Wages - TEMPLATE - MASTER.xlsx]01 MONDAY'!K9&"SL",0)))

I found the solution here: https://answers.microsoft.com/en-us/...b-68b599b31bf5

I copy it down here, in case the original post gets deleted for some reason:

---

Open destination workbook

In source workbook, right click on tab and select Move or Copy ...

In the To Book window, select the name of the destination workbook, and Select the tab in the destination workbook to insert Before

Click OK, which moves tab from source workbook to destination workbook

Close source workbook without saving

On the Data group, Connections Group, select Edits Links

Click on Change Source, then browse for the destination file (the one that is opened) and click ok

---

It works great.

Best regards,
Alberto