Pdf'ing - hyperlinks will be lost - help

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
 
D

David McRitchie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top