Is set to "convert entire workbook" and application setting of "Add bookmarks to PDF" is turned on. Is there some other setting that could have gotten changed, as this has worked in the past.
Worksheet names from Excel spreadsheet do not convert to bookmarks
2008-04-07 11:46:40
My Product Information:
Acrobat Standard 7.0.8, Windows
Acrobat Standard 7.0.8, Windows
2008-04-09 06:24:04
#2
PDFMaker macro, but have tried the other two ways also. Nothing works.
2008-04-09 06:33:50
#3
Is your entire worksheet converted? Do any bookmarks appear?
If you use the Create PDF menu in Acrobat, you'll need to turn on the Bookmarks in the following preference: Edit --> Preferences --> Convert to PDF category
Select Microsoft Office Excel and check the "Add bookmarks to Adobe PDF file".
Don't print to the Adobe PDF printer if you want bookmarks because this technique never produces them.
If you use the Create PDF menu in Acrobat, you'll need to turn on the Bookmarks in the following preference: Edit --> Preferences --> Convert to PDF category
Select Microsoft Office Excel and check the "Add bookmarks to Adobe PDF file".
Don't print to the Adobe PDF printer if you want bookmarks because this technique never produces them.
2008-04-09 06:47:16
#4
Yes, the entire workbook is converted--no bookmarks appear at all. The preference for bookmarks is turned on. I've tried other Excel files with the same result--no bookmarks. The only reason I tried from the Print menu (knowing that it doesn't generate bookmarks) was that I couldn't think of anything else!
2008-04-09 06:48:33
#5
What version of Excel/Windows/Acrobat is this?
2008-04-09 06:56:08
#6
Excel 2003, Adobe Acrobat Standard 7, Windows NT
2008-04-09 08:15:25
#7
You might try a Repair under the Help menu to see if it corrects the install. Were you using the same version of Excel when you could see the bookmarks?
2008-04-09 11:58:43
#8
This is happening on multiple computers with multiple different Excel files. Tried the repair on 2 different workstations--didn't work. And yes, we were using Excel 2003 when the bookmarks did work.
2010-01-28 04:13:05
#9
I have an excel workbook of many sheets each has different names. I used adobe Acrobat 8 standard and converted this excel workbook to PDF. But I can’t make a bookmark containing the names of the sheets. Please help me.
2010-01-28 06:32:47
#10
Do you have "Create bookmarks" selected under the Change Conversion setting menu in Excel? How are you creating your PDF from Excel?
2010-01-28 07:21:07
#11
I open excel workbook(2007), go to save as, chose PDF or XPS, chose PDF as save as type, go to option, select entire workbook, click OK, the click publish and I have PDF files. On the left side i have all the PDF as thumbnails and they are numbered.
2010-01-28 12:12:51
#12
You'll need Acrobat and not just the Microsoft add-in for Excel to convert your worksheet names to PDF bookmarks.
Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.