Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Advanced Filter With Hyperlinks (xp-pro - office 2003)

    good morning experts...

    if i copy data with hyperlinks using advanced filter, copy to another location, all data will be copied but the hyperlink address is lost...

    what am i doing wrong there?!

    thank you...

    best,
    wolfgang

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

    Re: Advanced Filter With Hyperlinks (xp-pro - office 2003)

    You're doing nothing wrong. Advanced Filter, Copy to other location only copies values and formats. Formulas and hyperlinks are not copied. If you want to copy the latter too, filter in place, then copy the filtered cells and paste them elsewhere. Formulas may not work correctly, however.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Advanced Filter With Hyperlinks (xp-pro - office 2003)

    hi hans...

    as always...fast, no frills and straight to the point...

    thank you very much and have a nice x-mas...

    best,
    wolfgang

Posting Permissions

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