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
|