Copy a worksheet to a new workbook without links

[shewcraft.ryan]

I have two workbooks that are identical except that one has a few
extra sheets on it. I want to move those sheets onto the second
workbook. However, when I try to do this, it keeps references linked
to the first workbook. Since I have all of the same sheet names in
both workbooks, these are unnecessary. Furthermore, they create
problems because the links make the formulas longer than the character
limit. Is there any way I can move the sheets without linking the
formulas?

Thanks,

Ryan

 

[Jim Rech]

After the copy use Edit, Links, select the old file, click Change Source and
pick the new file.

--
Jim
|I have two workbooks that are identical except that one has a few
| extra sheets on it. I want to move those sheets onto the second
| workbook. However, when I try to do this, it keeps references linked
| to the first workbook. Since I have all of the same sheet names in
| both workbooks, these are unnecessary. Furthermore, they create
| problems because the links make the formulas longer than the character
| limit. Is there any way I can move the sheets without linking the
| formulas?
|
| Thanks,
|
| Ryan
|

 

[shewcraft.ryan]

After the copy use Edit, Links, select the old file, click Change Source and
pick the new file.

That doesn't work because the formulas are too long and I get an error
when I try to update the links.

 

[Dave Peterson]

Maybe this'll work for you:

You could select the range to copy
(all the cells on all the sheets to be moved/copied???)
change all the formulas to strings
edit|replace
what: =
with: $$$$$=
replace all

Move/copy the sheets to the new workbook

and change all the strings back to formulas
(in both all the worksheets in both workbooks!)
edit|replace
what: $$$$$=
with: =
replace all