Thanks Sean,
I have used the instructions you provided (Save to PDF instead of Print to PDF) which is how I had previously created the PDF document anyway, directly from Excel (2010). The final product looks like it has hyperlinks in it as they are blue and underlined, but the hyperlinks are not actually interactive once they appear in the PDF.
I am only using the built-in PDF maker in the Microsoft Office Excel program.... any other suggestions?
Nicole.