ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Very slow unhidding rows Excel 2000 SP3 (https://www.excelbanter.com/excel-programming/361923-very-slow-unhidding-rows-excel-2000-sp3.html)

rs

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.


I tried running Excel WB rebuilder and that didn't fix the issue. I am
using Normal vew and auto calculation is not checked.


Any help is appreciated.



All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com