Forum Discussion
Excel Workbooks changing source
- 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
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?
- Looking at the image you just posted, try taking out the full path, ‘C:Dell\Users\.......xlsm!]
Charla74 leave the replace with blank? Not put in the new destination? I will try that right now...
