Preserving hyperlinks in exported PDF

I have an Excel workbook with about fifteen tabs that prints neatly as one page per tab. It's full of hyperlinks to web URLs, which I am creating with the HYPERLINK function.

(1) I want to export this workbook to a PDF that preserves these links. Nothing seems to work - print to excel, save to Excel... I also installed the latest version of Acrobat and tried their printer driver and export button (and yes I've checked "preserve links" in the Acrobat options) and none of that works either.

It seems like using "insert link" rather than the HYPERLINK function works better with one or two of these methods, but this is not practical given the number of links I'm dealing with.

It also seems like both methods really want to format the text blue and underlined, and when I change that formatting it removes the link status in some sense? Maybe this one is just in my head but it's confusing. I also sometimes see that the "Style" of these cells in the home toolbar has reverted to "Normal" rather than Hyperlink, but changing it back to Hyperlink doesn't seem to help either.

Can someone shed any light on all this? I'm interested in a VB solution too if that's the only option.

(2) Not sure if this is easier or harder, but I also want to insert links from the first tab (table of contents) to the others, in a way that will be preserved in the final PDF. Same problems as above. Not sure if there's one solution for both though.

Thanks!