What happens if you just open the other workbook and edit|copy and
edit|pastespecial values (or formulas).

If your formulas still point to worksheets in the original workbook, you may be
able to copy from the formula bar and paste into the formula bar.



E wrote:

Hi

I have a sheet where some of the columns are calculated as a combination
of data in other columns. I use formulas to do it.
When I want to copy any formula within the sheet it is easy using Spacial Paste.
I have also other sheets in the same or in other files which are very similar
but I don't know how to copy my formulas there.

Could anyone help me? I'd be very grateful.

Regards
E

--

Dave Peterson