Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy linked sheets (excel)

    Once I had my excel file corrupted and could not be saved, either as different name or same name. I tried to copy sheet per sheet in to new workbook, which were linked to each other.
    But the formulae still refer to original file, that made me re-wrote in new workbook/worksheet.

    Perhaps there are way in case happen again?

    many thanks

    -Indra-

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: copy linked sheets (excel)

    You can use Edit | Replace to change the references from the old workbook to the new one.
    Start by making a backup copy of your workbook.
    Open the new workbook
    Let's say that you have references looking like this:
    <code>
    'C:Folder[Workbook.xls]Sheet1'!A3
    </code>
    where C:FolderWorkbook.xls is the path and filename of the old workbook.
    Select Edit | Replace.
    Click Options >>
    Specify that you want to search the entire workbook.
    Specify that you want to search in formulas (this is the default)
    In the 'Find what' box, enter (or paste) the path and filename exactly as displayed in the formulas, i.e.
    <code>
    C:Folder[Workbook.xls]
    </code>
    Note that the apostrophes ' and the worksheet name have not been included.
    Leave the 'Replace box' empty.
    Click 'Replace All'.

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: copy linked sheets (excel)

    I will try soon, usually it always works..
    congrats for 50,000 post ya..
    forever thanks

    -indra-

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: copy linked sheets (excel)

    Thanks, Indra,

Posting Permissions

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