View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
david mcritchie david mcritchie is offline
external usenet poster
 
Posts: 691
Default Runs fast then slow

When you open your file Page Breaks will be off, when you print or
preview, or turn on page breaks they will be on and Excel will have
to spend more time figuring out what page something is on each time
you unhide a row.

If you want to actually compare times, there is code to check the time
difference between start and finish point that you include. You will find
the code near the end of the slowresp.htm page.

Whenever response questions are asked it is always a good idea to
include the version of Excel as well as the version of the operating
system. And as already pointed out the print drivers themselves could
be responsible for some of performance problems/solutions, but turning
of page breaks and screen updating should solve what you can see.
Used to be a lot of complaints about H-P printers, but I don't see such
complaints anymore, maybe that was mainly with Excel 95 and or
Windows 95 systems..

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm