Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CREATE MACRO TO COPY MULTIPLE WORKSHEETS | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Copy Excel worksheets | Excel Discussion (Misc queries) | |||
copy pivot table to multiple worksheets | Excel Worksheet Functions |