Copy worksheets with formulas between different workbooks

[Tim]

Hi

I want to copy a worksheet from one workbook to another
one.
To copy the worksheet I open the both workbooks right
click on the tab/move or copy/create a copy and select
the name of other workbook
Then I close the first workbook and save the second one
and the sheet is copied. The problem is that this
worksheet contains formulas and when I open it it asks me
to update the links. I go to Edit/Links/Break the link
because I don't need to have the link and it breaks but
after this the formulas on the copied worksheet
disappeared.
Is there any way to copy the sheet without links and also
to keep the formulas exactly the same as they are on the
sheet on the first workbook with no changes?

>-----Original Message-----
>Hi
>
>I want to copy a worksheet from one workbook to another
>one.
>To copy the worksheet I open the both workbooks right
>click on the tab/move or copy/create a copy and select
>the name of other workbook
>Then I close the first workbook and save the second one
>and the sheet is copied. The problem is that this
>worksheet contains formulas and when I open it it asks me
>to update the links. I go to Edit/Links/Break the link
>because I don't need to have the link and it breaks but
>after this the formulas on the copied worksheet
>disappeared.
>Is there any way to copy the sheet without links and also
>to keep the formulas exactly the same as they are on the
>sheet on the first workbook with no changes?
>
>.Is there any reason why you cannot select all, copy on
the original worksheet, then paste special values into an
empty worksheet in the new workbook?
>

[because i want to paste the formulas not values]

Because i want to copy to the new sheet the formulas not
values and i want this formulas to corespond to the
second workbook not to the first.


>-----Original Message-----
>
>>-----Original Message-----
>>Hi
>>
>>I want to copy a worksheet from one workbook to another
>>one.
>>To copy the worksheet I open the both workbooks right
>>click on the tab/move or copy/create a copy and select
>>the name of other workbook
>>Then I close the first workbook and save the second one
>>and the sheet is copied. The problem is that this
>>worksheet contains formulas and when I open it it asks
me
>>to update the links. I go to Edit/Links/Break the link
>>because I don't need to have the link and it breaks but
>>after this the formulas on the copied worksheet
>>disappeared.
>>Is there any way to copy the sheet without links and
also
>>to keep the formulas exactly the same as they are on
the
>>sheet on the first workbook with no changes?
>>
>>.Is there any reason why you cannot select all, copy on
>the original worksheet, then paste special values into
an
>empty worksheet in the new workbook?
>>
>.
>

[Tim]

I figured it out.
Sorry for taking your time.
Tim