Manually?

I just change my formulas to text, copy the strings, paste, then change my text
strings back to formulas:

Select all the cells (ctrl-a, twice in xl2003)
edit|replace
what: =
with: $$$$$= (some unique string)
replace all

Copy and paste

Select all
edit|Replace
what: $$$$$=
with: =
replace all

(don't forget to fix it in both workbooks--or close without saving the "sending"
workbook.)

TOMB wrote:

How do I copy formulas which read from several sheets within a workbook into
another workbook? Currently, as I copy from one book to another, Excel wants
to link the two books. The books have identical sheet names/page design.

Example:
Copy from:
MyFile.xls cell A1 formula
=Jan!C5+Feb!C5+Mar!C5+Apr!C5

Paste to:
Newfile.xls Cell A1 becomes:
='[MyFile.xls]Jan'!C5+'[MyFile.xls]Feb'!C5+'[MyFile.xls]Mar'!C5+'[MyFile.xls]Apr'!C5

Can I copy without linking?

Thanks in advance!

--

Dave Peterson