Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
rs rs is offline
external usenet poster
 
Posts: 4
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 so slow in vista woodis Excel Discussion (Misc queries) 1 December 23rd 09 12:45 AM
Stop rows that i have hidden unhidding when i filter in excel APS Dave Excel Worksheet Functions 0 October 5th 07 11:06 AM
Very slow unhidding rows Excel 2000 SP3 rs Excel Programming 4 May 19th 06 05:07 PM
Excel 2000 Slow Loops scain2004 Excel Programming 7 April 4th 04 02:35 AM
Slow Draw with Excel VBA 2000 Evan Excel Programming 0 September 4th 03 09:34 PM


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"