Merge Excel workbook with formulas into one
<p>So my issue is that I have 2 excel workbooks, both with formulas &amp; some VBA. I need to merged them into one.</p>

<p>The VBA part is easy to handle with the modules.</p>

<p>However, I DON'T want to have to redo all the references from the formulas. If I just copy the worksheets, then Excel will have the references to the source workbook, which I'll have to edit and that's a lot to edit (and potentially mess up).</p>

<p>Formulas are using all named ranges, and it's easy to make it so that all the named ranges used in each actually exist in the merged workbook. Also, there are no conflicts in existing named ranges.</p>

<p>I tried to copy the worksheets, then use "Edit Links" under Data to change the source. But that doesn't work (I get and endless suit of pop-pup windows telling me there's a problem with one of the formula... apparantely you can't change the source to the workbook itself).</p>

<p>Any smart ideas or do I have to brute-force this cell by cell?</p>

<p>To be clear: I'm not looking for a macro this is a one-off copy. Just want to handle the formula changes smartly.</p>