Break link in formula in Excel 2007

[Nick MSM]

I need to copy two Excel 2007 worksheets (WS1 & WS2) from one workbook to
another (WBX & WBY). WS1 has a formula referring to WS2. When I copy the
two WS's from WBX to WBY, the formula refers back to WBX. I need to break
this link to WBX so that the formula in WBY WS1 refers only to WBY WS2. Is
there some simple way to do this?

I don't know how to use VB yet.

 

[CLR]

If you only have one, or a few formulas to contend with, try just deleting
the equal sign in front of them, doing the copy and paste, and then
tr-inserting the equal signs in the new sheets.

Vaya con Dios,
Chuck, CABGx3