Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a worksheet to a new workbook without links
I have two workbooks that are identical except that one has a few
extra sheets on it. I want to move those sheets onto the second workbook. However, when I try to do this, it keeps references linked to the first workbook. Since I have all of the same sheet names in both workbooks, these are unnecessary. Furthermore, they create problems because the links make the formulas longer than the character limit. Is there any way I can move the sheets without linking the formulas? Thanks, Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a worksheet to a new workbook without links
After the copy use Edit, Links, select the old file, click Change Source and
pick the new file. -- Jim wrote in message ps.com... |I have two workbooks that are identical except that one has a few | extra sheets on it. I want to move those sheets onto the second | workbook. However, when I try to do this, it keeps references linked | to the first workbook. Since I have all of the same sheet names in | both workbooks, these are unnecessary. Furthermore, they create | problems because the links make the formulas longer than the character | limit. Is there any way I can move the sheets without linking the | formulas? | | Thanks, | | Ryan | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a worksheet to a new workbook without links
On Oct 10, 9:38 am, "Jim Rech" wrote:
After the copy use Edit, Links, select the old file, click Change Source and pick the new file. That doesn't work because the formulas are too long and I get an error when I try to update the links. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links - Copy a Workbook to another Directory | Excel Discussion (Misc queries) | |||
Links from one worksheet to another within the same workbook | Excel Discussion (Misc queries) | |||
how to copy whole Excell workbook without links? | Excel Discussion (Misc queries) | |||
Copy sheet - Break Links to Old Workbook - Retain Formula. | Setting up and Configuration of Excel | |||
COPY WORKSHEET WITH VALUES IN CELLS BUT WITHOUT LINKS | Excel Programming |