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