Page 1 of 2 12 LastLast
Results 1 to 10 of 11

copy one workbook into another without losing formula/links

This is a discussion on copy one workbook into another without losing formula/links within the Excel Questions forums, part of the Question Forums category; Doe's anyone know how to copy multiple workbooks which include formula links between the workbooks being copied into an existing ...

  1. #1
    New Member
    Join Date
    Jan 2004
    Posts
    3

    Default copy one workbook into another without losing formula/links

    Doe's anyone know how to copy multiple workbooks which include formula links between the workbooks being copied into an existing workbook whithout retaining links back into the original workbook i have coipied from.

  2. #2
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,461

    Default Re: copy one workbook into another without losing formula/li

    the only way i know how to kinda do what i think your talking about is to copy entire contents of sheet and paste special -> values.

    i don't think this is answering your question, but it's one way. sorry if i didn't help.
    Regards,
    Zack Barresse
    My book on Excel Tables
    ExcelTables.com
    All Excel Functions
    (If you would like comments in any code, please say so.)

  3. #3
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    67,764

    Default Re: copy one workbook into another without losing formula/li

    If you mean copying multiple worksheets from an existing workbook to another workbook, select all the sheets (click on the first tab then Shift+click on the last tab) and copy them all in one go.

  4. #4
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,461

    Default Re: copy one workbook into another without losing formula/li

    Andrew,

    would that not still retain the links though? if there is a way, i wouldn't mind knowing either.
    Regards,
    Zack Barresse
    My book on Excel Tables
    ExcelTables.com
    All Excel Functions
    (If you would like comments in any code, please say so.)

  5. #5
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    67,764

    Default Re: copy one workbook into another without losing formula/li

    If the "links" are only between the (grouped) worksheets, the formulas will refer to the sheets in the workbook to which they are copied, not to the sheets in the original workbook.

    Copying a single sheet will create a link to the original workbook.

  6. #6
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,461

    Default Re: copy one workbook into another without losing formula/li

    click, click...and it sinks.
    thanks!
    Regards,
    Zack Barresse
    My book on Excel Tables
    ExcelTables.com
    All Excel Functions
    (If you would like comments in any code, please say so.)

  7. #7
    New Member
    Join Date
    Jan 2004
    Posts
    3

    Default Re: copy one workbook into another without losing formula/li

    Maybe I wasn't that clear, I have two files with multiple workbooks in both, each file has formula that cross inbetween the workbooks but don't look outside the file. I need to copy all the workbooks out of one file into the other.

    When I do this the cells which had formula in them that reference workbooks in the same file that was copied look back to the original file I copied from.

    What I need to do is copy the multiple workbooks over without having the links back to the original file.

  8. #8
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,461

    Default Re: copy one workbook into another without losing formula/li

    i don't know if this helps, but i believe andrew is right.

    i linked cells in one workbook to other sheets in the same workbook. then i linked another cell from that workbook to another.

    when i copied all the sheets from the first workbook to the second linked workbook, all of the links from the pasted sheet, then referenced the cells in the workbook it was pasted into.

    maybe i'm just not getting what your asking either.
    Regards,
    Zack Barresse
    My book on Excel Tables
    ExcelTables.com
    All Excel Functions
    (If you would like comments in any code, please say so.)

  9. #9
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    67,764

    Default Re: copy one workbook into another without losing formula/li

    Your post is confusing because you keep using workbooks when you mean worksheets and file when you mean workbook..

    Open the first workbook, select all the sheets (by clicking the first tab and Shift+clicking the last tab) and copy them to a new workbook. Open the second workbook, select all the sheets and copy them to that new workbook. If you copy all the sheets at once like this, the formulas in the new workbook won't refer to the old workbook(s).

  10. #10
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,461

    Default Re: copy one workbook into another without losing formula/li

    i don't know if this helps, but i believe andrew is right.

    i linked cells in one workbook to other sheets in the same workbook. then i linked another cell from that workbook to another.

    when i copied all the sheets from the first workbook to the second linked workbook, all of the links from the pasted sheet, then referenced the cells in the workbook it was pasted into.

    maybe i'm just not getting what your asking either.
    Regards,
    Zack Barresse
    My book on Excel Tables
    ExcelTables.com
    All Excel Functions
    (If you would like comments in any code, please say so.)

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com