Pdf'ing - hyperlinks will be lost - help

  • Thread starter Thread starter Dianah
  • Start date Start date
D

Dianah

I'm trying to create a pdf with an excel file, but it tells me that links
etc will be lost if I don't clear the print titles.

The print titles is the repeating first row. This spreadsheet is simply a
contact list and is more than one page, so I want to keep ththe first row as
repeating on all pages.

How do I work around this. It's a contact list, so I want the links to
email addresses to remain as hyperlinks.

Thanks. Diana
 
Hi Diana,
You could easily record a macro to turn them off
File, Setup, sheet, Repeat rows at top
Print as PDF to a file from the File, Print menu
Restore your
File, Setup, sheet, Repeat rows at top: $1:$1

This does surprise me though what are you using for the
conversion to PDF, as I not noticed any similary questions
before. Do your hyperlinks by any chance have screen tips
besides titles. I can't understand why the program would
identify such things and not just do the right things since there
is only one choice that makes sense (I think).

BTW, you did test that the PDF conversion did not complain
if you did remove the repeating rows, didn't you. As I don't
see how this would have anything to do with hyperlinks.
 
Back
Top