If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
-----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? |
#3
|
|||
|
|||
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? . |
#4
|
|||
|
|||
I figured it out.
Sorry for taking your time. Tim |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save a copy of an excel file without the formulas? | Saving Excel File without Formula | Worksheet Functions | 1 | February 14th, 2005 08:55 PM |
Referencing worksheets in formulas | Carolyn | Worksheet Functions | 5 | September 7th, 2004 08:46 AM |
Inserting formulas in a path name (without having worksheets open) | Peter | General Discussion | 1 | July 2nd, 2004 01:07 AM |
Copy a column into many worksheets in a workbook. | Lisa | Worksheet Functions | 1 | December 9th, 2003 08:13 PM |