Prev: Match formula
Next: EXcel 2003 Page setup slow
From: Stu B Stu on 22 Apr 2010 00:33
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?
From: Bruce Sinclair on 21 Apr 2010 23:58
In article <89EB6D51-23CD-41EC-8DAD-648C74D1B04F(a)microsoft.com>, =?Utf-8?B?U3R1IEI=?= <Stu B(a)discussions.microsoft.com> 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?

The physical printer probably isn't, but if you changed printer driver (as
seems likely here), that might be. IIRC, changing printers (drivers
effectively) in XL 2003 sometimes slowed things down.

HTH

From: Gary Keramidas on 22 Apr 2010 01:08
may not be of much help, but go ahead and read this blog post.

http://blogs.msdn.com/excel/archive/2010/02/16/migrating-excel-4-macros-to-vba.aspx


--


Gary Keramidas
Excel 2003


"Stu B" <Stu B(a)discussions.microsoft.com> wrote in message
news:89EB6D51-23CD-41EC-8DAD-648C74D1B04F(a)microsoft.com...
> 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?

From: Dave Peterson on 22 Apr 2010 07:45
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
 | 
Pages: 1
Prev: Match formula
Next: EXcel 2003 Page setup slow