Printing problem #10

One of our staff has received a workbook with single page sheets in it. But 
every time we attempt to print it, the printer spews out 20+ sheets although 
the document only has one page and we can see the print area borders. How do 
we fix this?
Yours truly - Canadian Newsgirl
Newsgirl (2)
4/22/2005 4:29:06 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 43

Excel is pretty squirrelly when it comes to printing.
Highlight the area you want to print.
click File>Print area>set print area.

>-----Original Message-----
>One of our staff has received a workbook with single page 
sheets in it. But 
>every time we attempt to print it, the printer spews out 
20+ sheets although 
>the document only has one page and we can see the print 
area borders. How do 
>we fix this?
>Yours truly - Canadian Newsgirl
anonymous (74722)
4/22/2005 4:51:20 PM

Similar Artilces:

Print Command Button Corrupted
Hi Guys, Does anyone know how to recreate a corrupted button in Excel 2000? Basically the Print button comes up with error messages when I press onto it. Printing works fine if you select from the File menu, it is just the button. I thought there was a tool to recreate buttons but cannot find it. I have also run detect and repair which did nothing (Surprise surprise! lol) Any ideas would be much appreciated. Try this: In Excel XP, View, Toolbars, Customize. Select the Standard toolbar and Click the Reset Button. Note, that this will cause any customization that you may have made to you...

Calendar appointments dissapearing (Auto Accept Agent problem?)
I'm having a wierd issue where a meeting organizer will not me able to see a meeting they booked on their calendar but the meeting will still show up on the attendee's calendars. If I look at the meeting from the attendee calendar the organizer still shows up. Sometimes the meeting will stay for the organizer but they can't modify the meeting (no tracking tab, acts like they are an attendee instead of the organizer). This doesn't happen every time, in fact it happens a small amout of the time. We have the auto accept agent running and the organizers list the conference room...

Excel Database
I'm developing a database in Excel and I need some help with macros. The scenario: It's a database of drink short takes for a bar. Each tab has a different summary category, such as spirits, wines, cocktails, etc... Cells in each summary tab links to a new tab, where the data for that entry is explained (the short take sheets themselves). Short take planner Now, imagine a simple monthly calendar, each cell corresponding to each day of the month that has a drop down list of values to choose from. First, I would like to make this drop down list show data from the...

spreadsheet does not print as large as created
I have created a spreadsheet in Excel 2002. Simple layout with number, name, address,blank, blank,number. I created with large font size (28 or 32). I want the columns large enough for me to write in blanks and make notes. When the document is printed (hp laser 5p) the size of the font is not increased. Jim Morgan Memphis Tn Probably because that printer (driver) will not support that font and/or size. -- Don Guillett SalesAid Software Granite Shoals, TX "Jim Morgan" <> wrote in message news:06ce01c34dfe$29c53d90$

Printing Question
I have a report that I have been doing in Excel but is better done in Access. However, the report is too large to print on a single page and that is a necessity. With Excel, I just adjusted the scaling. I can't seem to do that with Access I've also tried exporting from Access to Excel, but the calculated fields are not exported. Any suggestions on how I can print the report on one page? Sorry, when I posted, it said there was an error and that I should try posting later. "randlesc" wrote: > I have a report that I have been doing in Excel but is bett...

i can change the font on the screen to be large but can't print t.
i am trying to make the print on my spreadsheet larger. i can change the font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!! Hi Maybe in the Page Setup you have this setting "fit to1 by 1 page" -- Regards Ron de Bruin "tj" <> wrote in message >i am trying to make the print on my spreadsheet larger. i can change the > font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!! ...

Determining and Printing a specific page
I have a HUGE Excel spreadsheet and I only want to print a certain page. Is there any way that I can tell what page the row resides on so that I can specifically print only that page of the spreadsheet??? Any help would be GREATLY appreciated! Thanks in advance! "wnfisba" <> wrote in message >I have a HUGE Excel spreadsheet and I only want to print a certain page. Is > there any way that I can tell what page the row resides on so that I can > specifically print only that p...

Authentication mode
Hi: Currently I have installed the MS CRM 1.2 Server on a server that host another application(sharepoint portal server & project server), this application requires SQL Authentication for work,but CRM requieres Windows Authentication Mode; at least the CRM implementacion guide document recommends this type of authentication, is there any way for work with both applications on same server ?. Microsoft CRM can work with SQL in mix mode authentication. Frank Lee Workopia, Inc. San Francisco, CA "Rafael Diaz" wrote: > Hi: > >...

New Problem
In 2007: In a form I created a button, used the wizard to set it to go to next record when clicked. When I click it, I get this: The expression ON CLICK you entered as the event property setting produced the following error: Ambiguous name detected: PRINT_CLICK. Now, if I wrote the VBA/Macro, I could understand it not working if I made a mistake, but this button was generated by ACCESS and doesn't work. Same problem with Previous record button and Save Record button. Thanks in advance, Vito On 13 May 2010 16:00:59 GMT, Vito wrote: > In 2007: > > In ...

Problems with Access 2000 reports in Access 2003
Hi, we have a sent out a 2000 format access database to a client running Access 2003. When trying to open any of the reports they get an error - "the openreport action was cancelled" - Not sure if they get this by running the report from the database window or if it's only when done through a form (buttons that run docmd.openreport when pressed). Is anyone aware of any issues that may be causing this? I couldn't find anything elsewhere on the MS site. Thanks - Angie P.S. the reports work fine in 2000 and XP. ...

URGENT!!! Problem with row data being truncated in a copy worksheet sub #2
Dave, Thanks for responding. I tried this but I could not get it t work in conjunction with the entire module. It dies right afte copying and PasteSpecial Values It does not kill the temp file or loa the newly created sheet into an e-mail. Any Ideas -- Doctor ----------------------------------------------------------------------- DoctorV's Profile: View this thread: You may want to post your current procedure. DoctorV wrote: > > Dave, Thanks for respon...

screen prints failing best demonstrated practice
When Outlook messages have screen prints embedded and the email is related and tracked in CRM the screen print does not come over to CRM. I understand this is not supported. But, what are practitioners doing to manage retaining these screen prints as pertinent background for the case. Looking for best practice. ...

print area #2
i cannot clear print area. when i select the print area and 'file', 'print area',the options are not available. any suggestions? When you use this command, Excel creates a range "print_area". Try deleting that range. Stan Scott New York City "bronxxbabe" <> wrote in message news:78dc01c476a2$31509280$a401280a@phx.gbl... > i cannot clear print area. when i select the print area > and 'file', 'print area',the options are not available. > any suggestions? Perhaps you have two or more ...

OFFSET problems in dynamic range
Hi, I'm having the strangest problem with the OFFSET function. I have 5 dynamic ranges in my worksheet. Aimline =OFFSET('Weekly ORF'!$F$4,1,0,COUNTA('Weekly ORF'$F:$F)-1,1) Sessions =OFFSET ('Weekly ORF'!$D$4,1,0,COUNTA('Weekly ORF'$E:$E)-1,1) WCPM =OFFSET ('Weekly ORF'!$G$4,1,0,COUNTA('Weekly ORF'$G:$G)-1,1) Date =OFFSET ('Weekly ORF'!Aimline,0,-1) Date2 =OFFSET ('Weekly ORF'!WCPM,0,-1) The problem is that the two names for Date and Date2 keep reverting to =OFFSET ('Excel Template.xls'!Aimline,0,-1) and =OFFSET (&#...

OnGetMinMaxInfo problem
Hi, I added an OnMinMaxInfo() function to my dialog so i can set the minimum tracking width and height for my dialog, I added this prototype to my dialog class: afx_msg void OnGetMinMaxInfo(MINMAXINFO* lpMMI); Then I added this function to set the min and max values: void CMessDlg::OnGetMinMaxInfo(MINMAXINFO* lpMMI) { POINT min; min.x = 200; min.y = 200; lpMMI->ptMinTrackSize = min; CDialog::OnGetMinMaxInfo(lpMMI); } It compiles but i can still resize the dialog to a smaller width/height, Any help would be apreciated :) Thx in advance, Thomas "Thomas" <Da_QuiK@fake...

Urgent Question Please Help: Credit Card Setup Problem
We have an urgent question regarding credit card setup/cash receipts/bank rec We understand that in Great Plains when setting up a Credit Card to be used by a Customer, it must be setup as a "Bank Card", not a "Charge Card", in order for the transaction to hit Bank Rec. However, we mistakenly setup all the Credit Cards as "Charge Cards", therefore after posting Credit Card Cash Receipt transactions in Receivables, the transaction does not appear in Bank Rec for us to perform Bank Deposits. Please Please Help!!! Is there any way to "fix" those pos...

Printing in Landscape mode
This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C8C04C.CC21E500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Is there a code snippet in which I can set the printer print-mode to = Landscape? Ideally, I want to set it in the MFC CView::OnPreparePrinting() method = call. If you have any suggestions... please help. King ------=_NextPart_000_000B_01C8C04C.CC21E500 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD H...

Problem running MS CRM 3.0 over SSL (https)
I have setup an install of Microsoft CRM 3.0 on a high spec Windows 2003 Small Business Server and it all worked happily. I then generated an SSL certificate and applied it to the site in IIS. Initially when you load CRM (using the web client) it loads the left hand menu and navigation panes and shows the top menus and the user which is logged in however to main content area remains blank. After a time out period the error "An error has occurred. For more information, contact your system administrator" appears. The strange thing is you can navigate the menus etc and even edit...

Type mismatch 04-02-10
Can anyone help? I am getting "Type mismatch (error 13)" when I try to call a method. The method is on a class module. The call is from a userform sub. The call: Dim DataSource as Leaf ... Set DataSource = new Leaf .... various properties of DataSource are used successfully ... .... then the problem call ... DataSource.Insert 1,"^" <<. msg occurs trying to execute this line .... The method: In class module "Leaf" ... Public Sub Insert (ipOrdinal, ipSubValue) Dim Ordinal Dim SubValue .... various statements .... call to another met...

Printing on 2 sides of a page?
How can I print a 2 page spreadsheet on the front and back of the same sheet of paper? Using Excel 2008. Thanks! It depends on whether your printer supports duplex printing. Check your printer's features to find out. If it does, the setting will be available in the Print dialog. You can also do a "manual duplex" job by printing page 1 (or 'Odd pages'), flipping the paper yourself, then print page 2 (or 'Even pages')... If it's only 2 pages that might be the simplest approach. -- HTH |:>) Bob Jones [MVP] Office:Mac "Rick"...

10 free copies of iPrep Microsoft 70-290 for your iPhone
iPrep Microsoft 70-290 is an iPhone app which will help you to prepare for Microsoft 70-290 certification exam "Managing and Maintaining a Microsoft Windows Server 2003 Environment". Download the app from the App Store: Use one of the following codes to get your copy for free: 9TM96E7EMNAY 6AYJTREAHM3A 94P4TJNAEHLW N636934JRPF9 3YKM9E66FF93 ENPN7PALXX9N XN6T993ANXTP TTEWEM4EEWLY 49RKEHHMMYF6 MXXA7HLLJMTM Each code can be used only once, first come first served. The codes are redeemable only ...

Print all records on a report ONLY IF Invoice NO is same
How do I get all the detail records for the same invoice no. to appear on the same page? Presumably you have 2 tables, such as: - tblInvoice (the header record), with fields: o InvoiceID primary key o ClientID relates to tblClient.Client o InvoiceDate Date/Time - tblInvoiceDetail (the line items), with fields: o InvoiceID relates to tblIvoice.InvoiceID o ProductID relates to tblProduct.ProductID o Quantity Number o PriceEach Currency etc. To create a report that looks like an invoice: 1. Create a query that uses both tables, along with...

Why are checks printing incorrect amounts? Please help.
When I print a Payables check batch, several invoices within the batch are printing incorrectly as $0.00 amount, even though it should be paying off a certain amount. The problem seems to be with invoices that are applied to credit memos. Say I have an invoice for $500 and I apply a credit memo of $80 to the invoice, when I go back to pay the invoice, it should pay $420, but instead it shows $0.00 under amount paid column of check stub. Does anyone know why this is occuring? By the way, I am using MICR check printing. ...

WindowsCE problems
I have some problems building application for Pocket PC (MDA1), maybe someone could help me. I have these two problems: -I need to create modal dialog box, but after creation sometimes I need to access it (in response to system calls) and show some messages... what is the best way to access modal dialog box while it's running? -is there a way to change colors of single items in list-view control ? Currently, when I'm using SetTextColor before each InsertItem, color changes but for all items in list-view (CListCtrl) :\ Is there way make this work? I'm using Microsoft eMbedded Visu...

Draft Folder problem #2
I'm running outlook 2000. My draft folder is called draft1. Can't seem to rename it! There isn't a folder named draft so what's happening? Isn't a big problem, but I should be able to solve it and I can't. Help. Thanks in advance Peter You could try to start Outlook from the run line with the /resetfoldernames switch. Start-->Run outlook.exe /resetfoldernames Reference: "Peter Brown" <> wrote in message news:TErag.449$ &...