Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Removing Links from Copied Worksheet

  1. #1
    New Member
    Join Date
    Jan 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a contract on worksheet A that has some links that are filled in from another sheet. I need to be able to export the contract to a new workbook, but when I do, it keeps the links. How do I export the sheet to a new workbook and remove the links, yet still keep the data that was supposed to be there?

  2. #2
    Board Regular s-o-s's Avatar
    Join Date
    Apr 2002
    Location
    Kissimmee, Florida
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 15:07, stumped wrote:
    I have a contract on worksheet A that has some links that are filled in from another sheet. I need to be able to export the contract to a new workbook, but when I do, it keeps the links. How do I export the sheet to a new workbook and remove the links, yet still keep the data that was supposed to be there?
    If your not fussed about maintaining the formulas, the easiest way is to Copy the entire sheet (Ctrl A) and paste special values into a new sheet. If you then do a second paste special formats you will keep all the formatting as well.



    Hope This Helps.
    Sean.
    Digest of Homes

    WinXP, XL XP

  3. #3
    New Member
    Join Date
    Jan 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That worked! Thanks. The only thing with copying you lose your page break formats, etc., but I can work through that. Appreciate the help!

  4. #4
    Board Regular s-o-s's Avatar
    Join Date
    Apr 2002
    Location
    Kissimmee, Florida
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 15:16, stumped wrote:
    That worked! Thanks. The only thing with copying you lose your page break formats, etc., but I can work through that. Appreciate the help!
    There's a fix on that too,

    1 Copy the whole Tab to a new sheet.
    2 Copy the sheet (Ctrl A)
    3 Paste Values over the top
    (You don't need to paste formats now)



    _________________


    [ This Message was edited by: s-o-s on 2002-05-08 15:20 ]

  5. #5
    New Member
    Join Date
    Jan 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Awesome!! Thanks a million.

Some videos you may like

User Tag List

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
  •