Forum Discussion
Excel Workbooks changing source
I have created a copy of worksheets in a workbook, and saved it as my new workbook. The issue is, it still has the original workbook in the formulas for numerous cells. How do I change this?
"How do I change it?" you asked, but you didn't specify what you wanted to change it to. That's important. Do you want to keep formulas "alive" but just referring to cells in your now new workbook? That's very different from just deleting the references to the old workbook.
So one thing I would strongly recommend, before you do ANYTHING, is that you make a back-up copy of what you have.
It's all too easy to do a search and replace, as Charla74 has suggested, and then regret the move. It's a good suggestion, in fact; it's what I would have suggested too, but first figure out what you want to replace it with, which may or may not involve leaving it blank.
