About Justin VanAlstyne Expertise I have a full working knowledge of Adobe Acrobat 5.0 - 7.01. I have experience in creating interactive PDFs, embedding multimedia, web-based forms, creating presentations using PDF, advanced prepress preparation, PDF web optimization, color management, and using PDF as a soft-proofing tool. I do not have a lot of experience using Acrobat`s advanced Javascripting features, though a lot of custom functionality can be built into a PDF this way.
Experience
Past/Present clients Marsh, Inc. (http://www.marsh.com), Impel Corp (http://www.impelcorp.com), Home Properties (http://www.homeproperties.com)
Question Hi there. I have an Excel spreadsheet with 8 worksheet tabs at the bottom. When I try to print all the worksheets using Acrobat PDFWriter, I get 3 seperate PDF files! The 1st PDF contains the 1st worksheet, the 2nd PDF contains the 2nd to the 7th worksheet, and the 3rd PDF contains the 8th worksheet. Why is it giving me 3 PDF files? I only want 1 PDF file. Is it a setting in Excel that I need to change?
I have created a visual animation of what's happening. You can view it at http://www.djmarxus.com/exceltopdf.html If possible, please view the animation, as it shows exactly what is going on. I need this problem solved. I can't end up with 3 PDF files, I only need 1.
I will give you a perfect rating and my most extreme thanks if you can answer this for me. Thank you so much.
Thanks again for your help,
Mark
Answer Mark-
Sorry Mark, I really can't replace Adobe Tech Support for problems like this. Have you tried contacting Adobe or MS about what's happening? I am an expert in Acrobat, but I just can't troubleshoot complex problems like this. This could be a bug in the PDFWrite printer driver, a problem with Excel, or just a freak Windows bug. I suppose there could be a rational reason for it, but there isn't anything that I can think.
