I'm using Excel 2007 (compatibility mode) with Acrobat 8 standard and have a similar problem as posted by annaherr "Problem convertin Excel file into pdf". I have a multi-tabbed Excel file with "print titles" and "print area" on certain worksheets. When I convert to a pdf I receive this error message:
"Acrobat PDFMaker cannot create Tags for worksheets with Print Area set. Clear the 'Print area' field in Page setup to get this feature.
Do you want to proceed and create a PDF file without Tags?"
If I proceed, a pdf is created, however the bookmarks do not point to the correct location. I've had to manually relocate the bookmarks. I've created a test file with just headers. If I remove the 'print area' and 'print titles', the bookmarks work fine, however on the normal file we use, we need the 'print titles'.
Is there a work around for this? I have a Table of Contents page with hyperlinks that work fine. Is there a process that can convert it to bookmarks?