Copy without function

[Guest]

I'm trying to copy a woksheet from one workbook to another
but do not want the file name attached to the function
(formula), just the function itslef, is there a way to do
this? Thanks in advance.

 

[Don Guillett]

One way would be to copy and then change the links.

 

[Guest]

Problem is that this worksheet exists in over 300
different files.

 

[Dave Peterson]

You want to preserve the formulas--no change at all?

select all your cells
edit|replace
=
with
$$$$$

(now all the formulas are simple text)

Do your copy and then change those $$$$$'s back to = (and excel will make them
formulas again).