cross workbook references

%3CLINGO-SUB%20id%3D%22lingo-sub-1889042%22%20slang%3D%22en-US%22%3Ecross%20workbook%20references%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1889042%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20working%20on%20a%20workbook%20with%20multiple%20worksheets.%20The%20worksheets%20have%20equations%20that%20pull%20data%20from%20other%20worksheets%20within%20the%20workbook.%20I%20want%20to%20copy%20a%20block%20of%20equations%20from%20one%20worksheet%20within%20the%20workbook%20to%20another%20workbook%2C%20but%20when%20I%20do%20so%20I%20can't%20get%20rid%20of%20the%20reference%20to%20the%20source%20workbook.%3C%2FP%3E%3CP%3EAny%20Ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1889042%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1889656%22%20slang%3D%22en-US%22%3ERe%3A%20cross%20workbook%20references%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1889656%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869786%22%20target%3D%22_blank%22%3E%40nileseh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20only%20need%20the%20values%2C%20copy%2C%20then%20paste%20as%20values.%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20keep%20the%20formulas%3A%20does%20the%20target%20workbook%20have%20worksheets%20with%20the%20same%20names%20as%20the%20source%20workbook%3F%20If%20so%2C%20you%20can%20use%20the%20Replace%20dialog%20to%20replace%20%5BSourceWorkbook.xlsx%5D%20with%20nothing%2C%20where%20SourceWorkbook.xlsx%20is%20the%20name%20of%20the%20source%20workbook.%20If%20the%20sheet%20names%20don't%20match%2C%20the%20formulas%20won't%20work%20anymore...%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm working on a workbook with multiple worksheets. The worksheets have equations that pull data from other worksheets within the workbook. I want to copy a block of equations from one worksheet within the workbook to another workbook, but when I do so I can't get rid of the reference to the source workbook.

Any Ideas?

1 Reply

@nileseh 

If you only need the values, copy, then paste as values.

If you want to keep the formulas: does the target workbook have worksheets with the same names as the source workbook? If so, you can use the Replace dialog to replace [SourceWorkbook.xlsx] with nothing, where SourceWorkbook.xlsx is the name of the source workbook. If the sheet names don't match, the formulas won't work anymore...