Copy without linking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi... I have 'workbook 1' with two sheets. Formulaes in sheet 2 are linked to sheet 1 data. I can't seem to copy sheet 2 to a new 'workbook 2' without Excel automaticaly linking formulaes to 'original woorkbook 1.' [just want sheet 2 formulaes in 'WB 2' to link to new 'WB 2', sheet 1] Thanks in advance, Jeff Mc
 
I do an Edit|replace
replace all =
with a unique string ($$$$$)

Then copy|Paste
then edit|replace
all $$$$$
with =

(for both workbooks.)

Another option is to let the links point at the wrong workbook/worksheet, but
then use Edit|links to point at the receiving workbook (already saved once).

Jeff said:
Hi... I have 'workbook 1' with two sheets. Formulaes in sheet 2 are linked to sheet 1 data. I can't seem to copy sheet 2 to a new 'workbook 2' without Excel automaticaly linking formulaes to 'original woorkbook 1.' [just want sheet 2 formulaes in 'WB 2' to link to new 'WB 2', sheet 1] Thanks in advance, Jeff Mc
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

links 1
Complex formula help , please. 13
Linking Formula 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Copy Exact Formula 1
cells linked from worksheet to worksheet 1
How do I link all dependent cells to a "new" independent cell?? 1
Replace worksheet without affecting the referencing formula 1

Back
Top