View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Print Causes Sheet Performace to Drop

Can you open the same workbook on another pc to test it?

And when you tested the other printer (or printer driver) did you use a local
printer or a network printer?

Jim Thomlinson wrote:

Nope... The issue actually comes up if I do something as simple as insert a
page break or a print preview... It seems like anything to do with printing
causes the problem. I have also tried using Code Cleaner and opening it on a
different machine. I am guessing corruption.
--
HTH...

Jim Thomlinson

"Dave Peterson" wrote:

A complete guess...

If you change to a different printer does the problem go away?

Jim Thomlinson wrote:

I am working on a spreadsheet that I inherited and I am having a problem. One
of the sheets performs fine until I do anything to print the sheet or to
modify any of the print settings. After that the sheet performance drops off
and any actions slow down to a crawl (even just scrolling up an down is
painfully slow). It only effects this one sheet and all other sheets perform
fine. The only way to fix the sheet is to close the spreadsheet and then
reopen it. It will once again work fine until I do anything associated with
the print functionallity. Before I go ahead and delete and re-create the
sheet (a task I am not looking forward to as it is full of named ranges and
such) I was wondering if anyone else has seen and rectified this problem. I
suspect that somehow the sheet has become corrupted in some way but I was
hoping someone else might have some guidance here.

As an aside it intermitenetly had the bizzare side effect of spontaneously
turning on Chip Pearson's RowLiner Addin when the print functionallity was
accessed. I completely removed the addin from my system but I am still having
the problem.
--
HTH...

Jim Thomlinson


--

Dave Peterson


--

Dave Peterson