Very slow unhidding rows Excel 2000 SP3
 

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.

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

Very slow unhidding rows Excel 2000 SP3
 

ps. you may want to toggle to manual calculation and do the work, then toggle
back to automatic.

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

Very slow unhidding rows Excel 2000 SP3
 

Thanks for your reply.

I got it in Normal view and Auto calculation is not checked. I tried to
unhide these rows from code and from design and it takes around 3 mins
but when hidding them it takes 2 secs. I tried a last week version and
it is fast. I also downloaded Excel WB rebuilder and that didn't fix
the issue.

Very slow unhidding rows Excel 2000 SP3
 

I got my issue resolved. I deleted some of the comments in one of the
sections and that fixed the issue. Not sure what was the problem.

Thank you