Edit-Replace worksheet reference nightmare
 

Hi all,
I have a worksheet that is a summary of another worksheet (both in the
same workbook). I want to copy the summary worksheet and have the
references to a fourth worksheet. However, when I do a simple
edit-replace for the worksheet names, all hell breaks loose. For every
replacement, xl asks for the workbook and worksheet (it would be easier
to manually replace the references). This is most bothersome as it
*seems* that it should be able to just take the new reference and be
done.

So my question is this: Can I replace the sheet reference (not the cell
reference) without xl going nuts?

Thanks, in advance, for any help.

Edit-Replace worksheet reference nightmare
 

I can't reproduce what you experience. I can copy the formulas to a new worksheet and then replace the references to the first
sheet with references to a 4th sheet.
What exactly are your actions?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MJL" wrote in message ups.com...
| Hi all,
| I have a worksheet that is a summary of another worksheet (both in the
| same workbook). I want to copy the summary worksheet and have the
| references to a fourth worksheet. However, when I do a simple
| edit-replace for the worksheet names, all hell breaks loose. For every
| replacement, xl asks for the workbook and worksheet (it would be easier
| to manually replace the references). This is most bothersome as it
| *seems* that it should be able to just take the new reference and be
| done.
|
| So my question is this: Can I replace the sheet reference (not the cell
| reference) without xl going nuts?
|
| Thanks, in advance, for any help.
|