If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printer Using USB Port Slows Page Setup
|
#2
|
|||
|
|||
Printer Using USB Port Slows Page Setup
Recently in Excel when I click on Page Setup or Print Preview, the response
time slows to a crawl, as does every operation after that, like scrolling or adding rows or columns. I recently installed an HP Officejet Pro 8000, which uses a USB connection to an older Dell desktop. This printer replaced an HP Laserjet which used an LPT1 cable. Is the USB connection my problem? |
#3
|
|||
|
|||
Printer Using USB Port Slows Page Setup
may not be of much help, but go ahead and read this blog post.
http://blogs.msdn.com/excel/archive/...os-to-vba.aspx -- Gary Keramidas Excel 2003 "Stu B" Stu wrote in message ... Recently in Excel when I click on Page Setup or Print Preview, the response time slows to a crawl, as does every operation after that, like scrolling or adding rows or columns. I recently installed an HP Officejet Pro 8000, which uses a USB connection to an older Dell desktop. This printer replaced an HP Laserjet which used an LPT1 cable. Is the USB connection my problem? |
#4
|
|||
|
|||
Printer Using USB Port Slows Page Setup
After you've done a print or print preview, you'll see that excel is displaying
those little dotted lines showing where the page breaks are. If you're inserting/deleting rows or columns, then excel has to recalculate the location of those dotted lines. So I'd try to remove those dotted lines to see if the response time comes back to normal. In xl2003 menus, it's: Tools|Options|View tab|uncheck Page breaks Stu B wrote: Recently in Excel when I click on Page Setup or Print Preview, the response time slows to a crawl, as does every operation after that, like scrolling or adding rows or columns. I recently installed an HP Officejet Pro 8000, which uses a USB connection to an older Dell desktop. This printer replaced an HP Laserjet which used an LPT1 cable. Is the USB connection my problem? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|