Question about Microsoft Office Standard for PC

1 Answer

Excel Print Queue Delay Problem

When I print (colated) multiple copies (66) of (2) sheets in an excel (2007) file, the print dialog box appears for each page over and over and will not let me access that file or any other excel file during teh entire print cycle. I do not remember this problem with 2003. How can I get the print job to "go" in its entirety and stop holding teh enitre program hostage while it goes through each print cycle?

Posted by on

  • 2 more comments 
  • agelmers Jan 08, 2009

    rmeyer, I appreciate your suggestions. I've tried it on 2 different printers with no success.



    frcs68, i was printing 66 copies of 2 sheets, it was collated.

  • agelmers Jan 09, 2009

    I've tried it on 2 printers: 1. TOSHIBA e-STUDIO282Series PSL3; 2. HP Color LaserJet 4600 PCL 6

  • Frank
    Frank May 11, 2010

    what printer are you using?

  • Frank
    Frank May 11, 2010

    did you specified how many copy and colated or not?

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Expert
  • 80 Answers

It has to do with your collate settings on your printers properties and the collate settings on your first print screen that shows up when you go to print. First when you are ready to print select print from the file menu in excel then go to the properties of the printer you are going to use and make sure the finishing properties are set the way you want them. Hit ok then you will be back at the first print screen. Here uncheck the collate box and then print. I am unsure but this may work. I had a similar problem a while ago and I know if I played with the collate check box it would print much faster other wise each time it was going to print a copy of the document it had to resend all the information again to the printer, which took forever.

Posted on Jan 08, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet


if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!

Feb 22, 2011 | Computers & Internet

Tip

How to recover Excel 2007 password


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password
Set a password to open Excel 2007
  • 1. Click the Microsoft Office Button 3dac3a8.gif, point to Prepare, and then click Encrypt Document
  • fd07008.gif
  • 2. In the Password box, type a password, and then click OK.
  • You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  • 3. In the Reenter password box, type the password again, and then click OK.
  • 4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet
  • In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  • 1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  • 2. On the Tools menu, click General Options. The General Options dialog opens.
  • 3. Under File sharing, in the Password to modify box, type a password.
  • 4. In the Confirm Password dialog, re-type the password. Click OK.
  • 5. Click Save.
Remove password protection from an Excel spreadsheet
  • 1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  • 2. Click the Microsoft Office Button 3dac3a8.gif , point to Prepare, and then click Encrypt Document.
  • 245e5bd.gif
  • 3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  • 4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007

on Jun 09, 2010 | Audio Players & Recorders

Tip

How to set, modify, remove and recover Excel 2007 password?


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password Set a password to open Excel 2007
  1. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document. excel-document.gif
  2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  3. In the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.
Remove password protection from an Excel spreadsheet
  1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  2. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document.

    excel-document.gif

  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
Related Office 2007 document password tips:
How to set, modify, remove and recover Word 2007 password?
How to set, modify, remove and recover PowerPoint 2007 password?

on May 21, 2010 | Computers & Internet

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

1 Answer

Link in excel 2007


right click on any cell then select hyperlink option from the list then a dialog box will appear infront of you
in left hand side pane there is option place in this document click on that then in right hand side pane select sheet 2 or sheet 3 whichever you want...
or if you want to open any other file so use existing file...option

Jul 01, 2009 | Computers & Internet

1 Answer

Bizhub 250 slow to print files


When you ask to print the page are you asking for more the one copy? If you are there is a collate check button next to the requested sets box, in the print dialog box. Make sure its not check. Collating the print means your PC sends a copy of the file for each requested copy. IE: you print one page and ask for six copies, your PC sends the file six times, one copy of the file for each print requested.

Also because your printing from a windows application IE: Excel you should be using the PCL print driver as apposed to a PostScript print driver. The time it takes to convert the file into PostScript for the printer to process it is time consuming.

May 08, 2009 | Konica Minolta bizhub 350 All-In-One Laser...

1 Answer

Unprotect an Excel sheet


Print or convert it to pdf then you may copy/paste from the pdf to a new unprotected sheet.

Doesnt work for formula.

Feb 18, 2009 | Computers & Internet

3 Answers

Excell 2007 very slow to open


Speed up Excel 2007 startup The Problem If Excel isn't running already, double-clicking a file will start Excel itself almost immediately, but the clicked file will be loaded only after about one minute.
The Solution At least on Windows XP the problem can be solved as described below.
  1. Application Explorer
  2. Menu Tools
  3. Menu item Folder Options
  4. Tab File Types
  5. List item XLS
  6. Button Advanced
  7. List item Open
  8. Button Edit...
In the dialog box that appears you need to make two adjustments:
Application to perform action:At the end of the line after /e append a space character followed by "%1" (including the quotes)DDE Application Not Running:Insert new text: [rem see command line] (including the brackets) Details We experienced the problem after updating to MS Office 2007. My father noticed that an Excel sheet gets loaded immediately if you include the path of EXCEL.EXE in the command line. Loading documents via DDE, as Explorer does it, seems to take much more time, at least if the application is not already running. The modifications described above will pass the file path immediately when the application is started, the DDE command that gets executed later on is only a remark, as an empty field would result in passing the default action from two lines above that field. The /e seems to ensure that Excel will not open an empty sheet, so I originally dropped that because usually no empty sheet is opened when a file is specified. However I got a report from someone using /e, and as it didn't cause any harm for me either, I now suggest to leave it in place. If Excel is running already, additional documents will be opened via DDE as before, resulting in only one Excel process running.
Word Time and again I've been asked whether I knew a similar trick for Word. Even without any tricks Word starts fairly fast, but even there adding "%1" gave me a slight increase in startup speed. I don't exactly know what this [REM _DDE_Direct] is. It looks like some kind of "special comment", that could have some effect despite being a comment. I decided to copy that comment to the DDE Application Not Running box, and could not detect any ill effects. I also kept the /n and the /dde on the command line, simply because I could find no harm in it.
Uninstall If you try out these suggestions, but they don't work out for you, reverting to the way it was before might prove more difficult than you would expect. It seems the dialog where you make your changes will always append a %1 to the command line when you press OK and it isn't present already. The only solution I could find was using regedit to remove the %1 without using the dialog. The command is stored under the default key at HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command. If you choose to revert the DDE settins using regedit as well, you can simply remove the whole ddeexec\IfExec subtree.

Feb 02, 2009 | Computers & Internet

1 Answer

Using Job Accounting with Excel


Try unticking the collate box on the print window. this can cause 50 jobs to be sent rather than 50 copies of the same job.

Hope this helps

Mar 27, 2007 | Canon ImageRUNNER 3570 Copier/Printer

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

424 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...