Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Links
I would like to copy a worksheet in one workbook with all the formulas,
formatting, etc. into another workbook that contains the same worksheets with the same names. When I do this it puts the old workbooks name in front of every link in the new pasted worksheet in the new workbook. I am trying to avoid this inserted workbook claim and instead keep it as just the original formula as if it were still in the original workbook. Is this possible? Ex. WorkbookA Worksheet1: contains formula in C1 = Worksheet2!N2 I then copy Worksheet1 and paste it into WorkbookB under a sheet titled Worksheet1. WorkbookB has a sheet titled Worksheet2 as well. When I do this I see in C1 of WorkbookB.Worksheet1 = [WorkbookA.xls]Worksheet2!N2 How can I get each cell with a linked formula to another worksheet to omit the [WorkbookA.xls] initially and only have C1 = Worksheet2!N2??? Please HELP!!! THANKS!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Links
One method......kludgy but effective.
In source workbook....... EditReplace What: = With: xxx Replace all. Copy to target workbook. EditReplace What: xxx With: = Replace all. Close source book without saving or reverse the EditReplace in that book. Gord Dibben Excel MVP On Wed, 16 Nov 2005 15:54:03 -0800, "KyWilde" wrote: I would like to copy a worksheet in one workbook with all the formulas, formatting, etc. into another workbook that contains the same worksheets with the same names. When I do this it puts the old workbooks name in front of every link in the new pasted worksheet in the new workbook. I am trying to avoid this inserted workbook claim and instead keep it as just the original formula as if it were still in the original workbook. Is this possible? Ex. WorkbookA Worksheet1: contains formula in C1 = Worksheet2!N2 I then copy Worksheet1 and paste it into WorkbookB under a sheet titled Worksheet1. WorkbookB has a sheet titled Worksheet2 as well. When I do this I see in C1 of WorkbookB.Worksheet1 = [WorkbookA.xls]Worksheet2!N2 How can I get each cell with a linked formula to another worksheet to omit the [WorkbookA.xls] initially and only have C1 = Worksheet2!N2??? Please HELP!!! THANKS!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt to update links | Links and Linking in Excel | |||
Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
Need listing of links in a worksheet | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |