Try this,
Select all of the worhsheets at the same time that you want to
copy from workbook to the other workbook and copy them
all in once to the new workbook. Then see if the filename is included.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"ProS" wrote in message ...

I have 2 excel documents.

I want to paste the formulas from one to the other, but without the
link to the other filename.

Is this possible? If so, how?




--
ProS