Copy worksheets with formulas between different workbooks
 

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 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?

.

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