Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Taunton, Somerset, England
    Posts
    27
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Copying names (2000 SR-1)

    I am trying to copy a worksheet that has a lot of cell names.
    every thing else is being copied OK, but not all the cell names.
    why is this?

    Thanks
    Jim.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying names (2000 SR-1)

    I suspect because you now have two sheets with the same names in your workbook. I don't know to which sheet the globally defined names will refer, press goto and enter the name to find out.

    Either the source sheet or its copy will have local sheet names, that is, the name is preceded by the name of the sheet.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Taunton, Somerset, England
    Posts
    27
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Copying names (2000 SR-1)

    I actually opened a new workbook and copied to that.
    some of the names copied, but not all.

    Jim

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying names (2000 SR-1)

    Is it possible that the names that did not copy are not being referenced in any of the sheets?
    Legare Coleman

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying names (2000 SR-1)

    Could you show us an example of name(s) that did not copy (with their refers-to formula?)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Lounger
    Join Date
    Jan 2001
    Location
    Taunton, Somerset, England
    Posts
    27
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Copying names (2000 SR-1)

    Sorry I've left this so long, Jan Karel, I've been off for a couple of days with a bit of a cold.
    Came back to the lounge today to get back to you, and found a post "Save a sheet as a workbook" with the suggestion from Tong Pak to try EDIT> MOVE OR COPY SHEET.
    This worked, of course, copying *all* the names.
    Thanks anyway,

    Jim

Posting Permissions

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