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 |
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 | |
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. |
Copy a worksheet to a new workbook without links
Maybe this'll work for you:
You could select the range to copy (all the cells on all the sheets to be moved/copied???) change all the formulas to strings edit|replace what: = with: $$$$$= replace all Move/copy the sheets to the new workbook and change all the strings back to formulas (in both all the worksheets in both workbooks!) edit|replace what: $$$$$= with: = replace all wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 11:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com