Forum Discussion
Excel Workbooks changing source
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
Without seeing the actual sheets you're working with, it's hard to be really specific or even appropriate in our suggestions.
One thought that occurs to me--that I've used under similar circumstances--is wherever possible to simple enter a correct new formula in one of the cells and then copy it throughout the rest of the worksheet. That may not work--depending on how the sheet is organized. If you have distinctive formulas in all those columns, for example, then you need to make separate and distinct corrections.
Is it possible to actually upload a sample of the actual sheet?
- TerraBruns if you’re just removing links to the source data (where it was copied from) - using the find / replace - just select the entire sheet, then input the full path / file name into the ‘find’ box ‘C:\Users\DELL\.......di terra.xlsx] , leave the replace box empty and select replace all. You will need to do this in each sheet but the details should remain in the find / replace dialogue box.
- In fact, I believe there may be a check box in the find / replace for all sheets ( working from memory here)...
- I’ve also assumed here that your new workbook contains all the same sheets referenced in the original. That means you will have issues if there are links on a sheet called Brun1 to a sheet named, say Terra1, in the original - if you then only copied sheet Brun1 into a new workbook and remove the links to the original, you have formulae in the new workbook looking for a sheet named Terra1, which doesn’t exist.
