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 Very slow unhidding rows Excel 2000 SP3

If you're unhiding rows a row at a time, make sure you turn off pagebreak
indicators before you start. And make sure you're not in pagebreak view, too:

ActiveSheet.DisplayPageBreaks = False
ActiveWindow.View = xlNormalView

would be near the top of your code.

rs wrote:

Hello everyone.

I am encountering a very strange behaviour. Last week it was taking
almost 2 sec to unhide/show 10,000 rows. But, today it is taking almost
3mins to show the same rows.I opened a last week version of the
workbook and it took 2 secs to show the rows.

Hidding rows works fine.

Does that mean the workbook got corrupted? How can fix that.

Any help is appreciated.


--

Dave Peterson