AppleNova Forums

fwtong · 2006-06-17, 00:39

I've created a workbook with 5 sheets in excel. I'd like to create a pdf that's 5 pages long, each sheet being 1 page. When I use the Save As PDF feature in the print dialog box, I only end up with a pdf file that only has 1 sheet in it. I have selected the print entire workbook function. Any ideas how to get around this?

torifile · 2006-06-17, 07:22

How does it look if you press "Preview" rather than saving it as a pdf. This may be a stupid question, but does it print correctly? I mean, to paper?

fwtong · 2006-06-17, 21:25

Everything looks fine, except when I do Save As PDF, only the last sheet gets saved as a pdf.

torifile · 2006-06-18, 00:06

And what if you choose "Preview" from the print dialog box? If it prints fine and it Previews fine, you should be able to get a .pdf that works from Preview.

Anonymous Coward · 2006-06-18, 03:56

I tried this. Quick preview only showed one sheet with "active worksheets" selected. When "entire workbook" is selected, quick preview shows all six sheets, but print to PDF only yields the one sheet, as the original poster experienced.

fwtong · 2006-06-19, 22:35

When I click on the Preview button, I end up with 5 windows, each displaying 1 sheet. I guess that's the problem is Excel's printing considers each sheet in the workbook as a seperate print job instead of 1 print job with each sheet being a different page.

Posting Rules	Navigation
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off	Post Reply Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mactel Camino PDF Problems	Mac Donald	Genius Bar	12	2006-04-25 14:10
Problems with making PDF files	chewman	Genius Bar	0	2006-02-26 20:27
combine PDF files?	jsk173	Third-Party Products	5	2005-06-12 18:52
Problems with iTunes Reading .mp4 Files	leachio	Genius Bar	4	2005-05-04 15:29
PDF files	JamesG	Genius Bar	7	2004-11-22 14:16

fwtong Member Join Date: Oct 2005	2006-06-17, 00:39 I've created a workbook with 5 sheets in excel. I'd like to create a pdf that's 5 pages long, each sheet being 1 page. When I use the Save As PDF feature in the print dialog box, I only end up with a pdf file that only has 1 sheet in it. I have selected the print entire workbook function. Any ideas how to get around this?
	quote

torifile Less than Stellar Member Join Date: May 2004 Location: Durham, NC	2006-06-17, 07:22 How does it look if you press "Preview" rather than saving it as a pdf. This may be a stupid question, but does it print correctly? I mean, to paper?
	quote

fwtong Member Join Date: Oct 2005	2006-06-17, 21:25 Everything looks fine, except when I do Save As PDF, only the last sheet gets saved as a pdf.
	quote

torifile Less than Stellar Member Join Date: May 2004 Location: Durham, NC	2006-06-18, 00:06 And what if you choose "Preview" from the print dialog box? If it prints fine and it Previews fine, you should be able to get a .pdf that works from Preview.
	quote

Anonymous Coward Member Join Date: May 2004	2006-06-18, 03:56 I tried this. Quick preview only showed one sheet with "active worksheets" selected. When "entire workbook" is selected, quick preview shows all six sheets, but print to PDF only yields the one sheet, as the original poster experienced.
	quote

fwtong Member Join Date: Oct 2005	2006-06-19, 22:35 When I click on the Preview button, I end up with 5 windows, each displaying 1 sheet. I guess that's the problem is Excel's printing considers each sheet in the workbook as a seperate print job instead of 1 print job with each sheet being a different page.
	quote

User Name		Remember Me?
Password

AppleNova Forums

Problems creating pdf files from Excel 2004