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