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?
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.
Charla74 leave the replace with blank? Not put in the new destination? I will try that right now...