I discovered a problem with creating a PDF from a workbook with multiple pages in the spreadsheet. The PDF converter was splitting up 3 and creating 2 PDF files, one with one page and 1 with the remaining 2 pages. After a bit of research, I discovered that the custom footer on 1 of the pages was preventing it from attaching to the other 2 pages in the spreadsheet....SOLUTION- all pages in the spreadsheet must be formatted the EXACT same way to be included in one PDF file. If one page has a footer, all must have the same footer!!!