Very slow unhidding rows Excel 2000 SP3

[rs]

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]

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.

 

[Dave Peterson]

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

 

[rs]

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.

 

[rs]

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