Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   Uncheck collate by default to avoid printer error When I print multiple copies of an Excel document (Excel 2003 or 2007 on Windows XP) it prints one copy OK, then generates an error on the printout. (The problem is very similar to the one discussed in http://support.microsoft.com/kb/948349, but that solution is for a different OS.) To avoid this error I need to uncheck the "collate" option in the Print dialog box. Fine. Is the... 2 12/29/2008 7:07:18 AM Hide text when printing Hello. I have a report that I've created in Excel that I'm having trouble printing properly. The report has alternating group colours - e.g. the first group could be rows 2 through 5, and all these will have a white background; the second group could be rows 6 and 7, and these will have a grey background; the 3rd group could be rows 8 through 15, and we're back to a white background, ... 2 12/29/2008 7:04:06 AM Printer not installed error - when 3 are installed Windows Vista Ultimate 64 with Office XP Pro. Running about a year with no printing issues. Today, the Excel application [only] cannot find the installed printers and tells me so at every turn. All other Office applications can continue to print to the printer without issue. Excel also now displays the EULA every time the application is opened, even though I have accepted the EULA ma... 3 12/19/2008 8:53:53 PM draft printing Hi, I want to get color printouts in draft When I print all worksheets in a file only the first worksheet matches the printout criterium, all athers are printed in high quatlty. I setthe proerties of the printer in draft and color but this doesn't make any difference... What to do? Thanks... 5 12/18/2008 12:49:33 PM Image resizes while printing Hi, I have an image that is imported into Excel. The image always gets shrunk vertically slightly when I print it out in Excel. Is there any way to preven Excel from resizing the image for printing?... 3 12/2/2008 2:29:00 AM Problem with Excel Printing Printing to network (NAS) printer works with all Office 2007 programmes except Excel, which will preview a sheet but no printout occurs. No document appears in print queue. OS is Vista Ultimate with all updates installed. If I use Excel 2003 on another PC, under XP Professional, sheet will print. Does anyone have any suggestions, Thanks, Mike.... 3 11/21/2008 12:05:01 PM Select printer via IP address If i record a macro to select a printer, it records the printer name. Is it possible to select a printer by it IP Address on a network instead via a macro? If so what code would set this? -- Corey .... The Silliest Question is generally the one i forgot to ask. ... 1 11/20/2008 3:44:37 AM Macro for deleting rows and serialising the remaing rows Macro for deleting rows and serialising the remaing rows ==================================================== I have a spread sheet It's a ToDo List The structure is like this Column A Sl No Column B Task Column C Person Column D Completed To start with I keep entering the tasks in one stretch and take a print out. The first Column (A) will be a serialized. ... 1 11/12/2008 12:29:52 PM Fonts too large when printing from Excel in TS Environment. I am printing an excel spread sheet from a TS application in MS Navision. The printing is coming out way too big. Is there any settings to look for. I have installed the correct driver on both the TS and laptop. Thanks... 1 11/11/2008 1:25:03 PM "Shrink to fit" option doesn't work My "shrink to fit" option doesn't work. When I have a large worksheet and select this options, the preview only shows a single cell with the content of first cell in the worksheet, and nothing else. This single cell is printed in its normal font size, i.e., no enlargement, and I can't print the rest of the worksheet Sometimes the behavior is even stranger: it shows thousands of empty p... 2 11/9/2008 12:43:00 AM No zoom during preview? This is odd. For some reason, Excel is not giving me the option of zooming during print preview. Don't think I changed anything, but this is definitely new. Zoom button is grey'd out, and mouse doesn't seem to allow any zooming either. Not sure if it's related, but when I edit text directly in cells, the cursor is more of a rectangular block rather than a single line. Thought it mig... 3 11/8/2008 2:21:01 AM Problems with Print Macro I have created a small macro and assigned it to a button that selects a number of worksheets and then prints these to the selected printer - 2 problems happen either - - only first 5 pages of 12 come out on printer OR - get error 1004 Macro code is - ============================================== Sub Print3() ' ' Print3 Macro ' ' Sheets(Array("MoM", "Development", "Delivery ... 1 10/30/2008 8:46:01 AM Repeating content of merged cell on next page Hi, in my tables I have some headers with merged cells. When printing, these merged cells can span several pages, but the content is printed only once, resulting in the spanned cells having no content in some pages (i.e. the text fits into page 1, span continues to pages 2 and 3, but without text there). I did try this also with Excel Pivot tables, which have similar structure as my tab... 2 10/25/2008 7:52:00 PM Getting a Printout With The Error We've been having a small printing issue for the last week or so, where, when trying to print documents from MS Word or MS Excel, we end up getting a printout with the following: PCL XL error: Subsystem: KERNEL Error: IllegalOperatorSequence Operator: EndChar Position: 23... 2 10/25/2008 7:47:00 PM Use AutoFilter to Print Only Filtered Data I have a large list of products that are in production on a worksheet. Each product has its own row and an associated sales person intials which is located in Col. C. I have a userform that contains a listbox of the sales persons intials. When the user wants to print all the products associated by a particular sales person, the userform is called, select the sales person from a listbo... 2 10/24/2008 11:42:00 AM on second page heading from a1 is truncated on repeat row I have selected to repeat row 1 the correct way. One page one it say Home Budget HOme is at the end of column a and budget moves onto overflow into column B I am also repeating column A(but evenif I take that away I still get the problem) when I go to page 2 the heading just reads HOME and the word budget is missing the only way it works is to widen column a and I don't want to do ... 2 10/22/2008 3:24:01 AM no zoom in print preview on a landscape-oriented page I'm stumped. The option to zoom is not available when viewing a worksheet in print preview. This seems to occur on all landscaped sheets. Portrait worksheets are not effected. Is there a fix? Anyone? Found only one other guy on the web asking the same question in various forums - no one responded to him. Thanks.... 10 10/20/2008 1:21:01 PM Excel prints rubbish to HP Laser Excel 2003, WindowsXPPro, In SBS2003 environment, HP4015N Laser. We have a SBS2003 network with a HP4015N Laser printer shared from the server to all workstations. One new workstation running Windows XP Pro, Excel 2003 has been unable to print (any) Excell 2003 worksheet correctly to the laser printer. All other workstations in the network do not have the issue and can print Excel 200... 2 10/19/2008 5:40:00 AM Excel not printing to PDF Hi I have Excel 2007 and Acrobat 5 All has been working well for ages Currently excel refuses to print to PDF All other applications ( incl Office 2007) work fine printing to PDF. When printing to Acrobat the dialoge indicates that printing is taking place but no document is produced. Additionally I do not get the normal Acrobat "Save as file name" dialoge box Thanks - any ideas appreci... 2 10/14/2008 11:52:57 PM Borders are not printing to PDF as they are formatted I am using a light(25%) Grey border with the style being the 1st option below None(light dotted line). All looks ok on the screen, but when printing to pdf or to simply print out on paper, the borders are standard Black constant line? I looked at the print quality on both printers, and it is set to high. Anyone over come this? How ? -- Corey .... The Silliest Question is generally... 1 10/9/2008 10:38:50 PM Eat Cookies and Loss Weight. See How Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Summer Weight Loss Recipes. Lose weight eating cookies and more! Get into shape for the summer! We have easy to make recipes for all weight watchers! The website is full of great links from our partners. Please stop by and support us. Visit all our links and choose the best websites ... 1 6/30/2007 8:32:30 AM Excel 2007 - Unable to fit document to one page for printing. I have created a document of 11 columns by 40 rows. When I set the document to 1 page wide by 1 page high for printing. The document become 440 pages. I also get this message "Margins do not fit page size". I have try all the settings and can not get to print this document in one page. I do not encounter this problem in Excel 2003 when doing the same thing. ... 2 6/29/2007 4:03:32 PM Page Setup - I need my sheet to be 1 page wide by 1 page tall, but ALSO >100% Greetings all, I can't seem to get Page Setup to make my sheet print 1 page wide by 1 page tall, but ALSO >100%. When I select "1 page wide by 1 page tall" it defaults back to 100%. BTW, I don't know if this makes a difference, but what I'm trying to set up is part of a larger spreadsheet, where I've hidden the lines I don't want to see. Help? Thanks, Liz ... 2 6/29/2007 10:08:00 AM Blank area on top Hi all, Sometimes, there is an empty area on top of my report's last page. Could you tell me why and how to cure it? Clara -- thank you so much for your help... 3 6/25/2007 1:43:00 PM Diabetic Recipes and More... Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Mr. Emeril Lagasse's fine recipes along with recipes for diabetic's. The website is full of great links from our partners. We have links to free cookbooks and more. Please stop by and support us. Visit all our links and choose the best recipe for you or your family. We look forward t... 1 6/24/2007 8:27:14 AM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12