moving sheets between workbooks?

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I made a copy of my workbook before adding to it for obvious reasons, but
now when i copy the new sheet to the original wookbook all the formulars are
poniting to my backup copy. how can i stop it doing this? or quicky make it
use sheets from within the current workbook?

Many thanks,

Steve
 
Your choice on what's easier for you.

To correct the links *after* copying (moving) the sheet:
<Edit> <Links> <ChangeSource> button,
In the "ChangeLinks" window, link to the present WB, which in essence, is
linking to itself, which re-directs the links to the WB you're in.

To prevent the mis-direction of existing formula links in the first place,
"unformulate" the formulas *before* you copy or move the sheet to the main
WB.

In other words, change your formulas to "non" formulas by replacing the
equal sign with an odd character, and then return the equal signs after the
copy (move) is completed.
<Ctrl> <A>, to select the entire sheet, then
<Edit> <Replace>
Find What - "=" (no quotes),
Replace With - "^^^" (no quotes).
Now, complete your copy or move, and then return the equal signs,
<Ctrl> <A>, to select the entire sheet again, then
<Edit> <Replace>
Find What - "^^^" (no quotes),
Replace With - "=" (no quotes).
 
Thanks Ragdyer!


Ragdyer said:
Your choice on what's easier for you.

To correct the links *after* copying (moving) the sheet:
<Edit> <Links> <ChangeSource> button,
In the "ChangeLinks" window, link to the present WB, which in essence, is
linking to itself, which re-directs the links to the WB you're in.

To prevent the mis-direction of existing formula links in the first place,
"unformulate" the formulas *before* you copy or move the sheet to the main
WB.

In other words, change your formulas to "non" formulas by replacing the
equal sign with an odd character, and then return the equal signs after the
copy (move) is completed.
<Ctrl> <A>, to select the entire sheet, then
<Edit> <Replace>
Find What - "=" (no quotes),
Replace With - "^^^" (no quotes).
Now, complete your copy or move, and then return the equal signs,
<Ctrl> <A>, to select the entire sheet again, then
<Edit> <Replace>
Find What - "^^^" (no quotes),
Replace With - "=" (no quotes).
Click to expand...
 
Back
Top