 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / June 2005Printing a Workbook in Microsoft Excel =?ISO-8859-1?B?uyA=?=PDF
In an attempt to PDF a workbook in Excel, I encounter the following problem: The user is prompted to save the workbook with one file name. If the workbook contains multiple pages, then each worksheet is outputted as a PDF, but each of them to the same file name. Thus, the final product is only the final worksheet in the workbook. O Microsoft, why must thy overlooking of details be so prevalent! Maybe someone has a simple solution. Grazie, san Do you have this problem if you "Save as PDF" in the Print dialog box If you can get it to spit out multiple pages you can gather them wit Acrobat Pro into one doc If you're getting one file saved over an over, there must be a settin that's selected that you don't want, like "multiple pages" or "singl page" that you can toggle Let me know if any of this helps. I too hate trying to output file from Microsoft products, and so do printers -- Natobass flikworld(dot)co bass 20 years. macs 20 years imac g4 17\" | powerbook g3 (pismo macosx.com - The Answer to Mac Support - http://www.macosx.co Le 04/06/2005 18:51, dans Natobasso.1q42nz@nomx.macosx.com, « Natobasso » <Natobasso.1q42nz@nomx.macosx.com> a écrit : > Do you have this problem if you "Save as PDF" in the Print dialog box? At least it works with Excel 2004 on Tiger... I did not try with much "decoration" though. yes, it does, but only if you have the original three sheets in th workbook. It will not do it with anything els -- mcohe macosx.com - The Answer to Mac Support - http://www.macosx.co Le 30/06/05 22:52, dans mcohen.1rgj3z@nomx.macosx.com, « mcohen » <mcohen.1rgj3z@nomx.macosx.com> a écrit : > yes, it does, but only if you have the original three sheets in the > workbook. It will not do it with anything else Right. It prints the 6 pages I tried in the same file. I can't believe that ! Yet, "preview" works, and opens 6 pdf files in Apple Preview. Then it's easy to save them (but they have the same name in preview, how fun :-)). Dunno if it's the same quality, though. Le 30/06/05 23:43, dans BEEA3421.22D9%jean-claude.arbaut@laposte.net, « Jean-Claude Arbaut » <jean-claude.arbaut@laposte.net> a écrit : > Le 30/06/05 22:52, dans mcohen.1rgj3z@nomx.macosx.com, « mcohen » > <mcohen.1rgj3z@nomx.macosx.com> a écrit : [quoted text clipped - 3 lines] > > Right. It prints the 6 pages I tried in the same file. I mean: you get only one sheet, all others are overwritten. Of course. > I can't believe that ! > > Yet, "preview" works, and opens 6 pdf files in Apple Preview. > Then it's easy to save them (but they have the same name in preview, how fun > :-)). Dunno if it's the same quality, though. Yes, I know this is a nightmare. I have been trying to do this as well I was on the phone with Microsoft for an hour and they had no solution yet did not state that they were aware of it and that it is impossible they pretended that it should be possible. You can make a pdf file fro a workbook including all sheets with each sheet as a page in the pdf b opening a new workbook and keeping your workbook to 3 sheets (default) if you want to do it with an old workbook, no dice. if you want to mak a larger workbook, no luck. This is the only way I do it: I save eac individual worksheet as a separate pdf file. then I use Adobe Acroba to make a the pdf file from those individual pdf files. what a pain and I had to buy acrobat (btw, I called adobe BEFORE I bought th software and asked them: Can I do exactly this with an excel documen and easily make a pdf file from a workbook? They said yes you nee adobe acrobat 7.0 standard. Well, you can't. But you can on a PC usin Windows, because adobe's software is actually more complete for PC. I is almost like they cut corners. It is very hard to tell if this is problem with MAC OS X, Microsoft, or Adobe, because it is all tied int the print drivers. I am using MAC OS X 10.4.1, Adobe Acrobat 7.0, an Microsoft Office 2005. PLease let me know if you find anything out Hope this helps -- mcohe macosx.com - The Answer to Mac Support - http://www.macosx.co |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.