Recent content by JNM

  1. J

    How do I copy Hyperlinks from a cell in 1st workbook to another cell in the 2nd workbook?

    I can use the copy/paste special (paste link) to transfer the link to the next workbook, but when I go to open the hyperlink in the 2nd workbook it says "Cannot open specified file". Excel even colors it blue, like it is active. Any suggestions would be greatly appreciated. Thanks, John