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?
12 Replies
"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.
- You can copy / paste values if you don’t need to maintain any formulae from the source data, otherwise select all data in the pasted sheet and use find & replace (Ctrl+H)....find the text linking to the old worksheet and leave the replace with field blank - click replace all.
- Now I get a dialogue box that says that sheet (current sheet name) is not found in (current sheet name) and wants to know where I would like to put it in the order of my other sheets...
Okay, so I have been on one worksheet 'replacing all' choosing the source workbook, then clicking the worksheet I want it to use, and I have been doing the same sheet for 35 minutes...is it feasible that I would have to do this? Step 1:
Step 2:
Step 3
Charla74 leave the replace with blank? Not put in the new destination? I will try that right now...
