LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 5th 05, 12:21 AM
Simon Shaw
Posts: n/a
Default hidden rows & columns slow file open


I have found that if I have extensive Rows and Columns Hidden in the Sheets
of a large Workbook, that it causes Excel 2000 to take a long time to open a
file. It opens quickly in version 2003. If I set all Columns and Rows to
Hidden = False during the BeforeSave event in ThisWorkbook sheet, the file
re-opens quickly. Note: During use of the workbook I have individual
Worksheet_Active event procedures that set certain Rows and Columns to Hidden
= True based on various criteria.

Is this a known issue, and the only solution? It makes saving the file
slow... not as slow as opening, but it is a compromise. It was taking so long
to open the file, that users were calling thinking there was a problem...
rather than waiting for the file to eventually open - 30 to 40 seconds, which
causes just about anyone to think there is a problem. now it open in about 5
to 8 seconds with all the Rows and Columns set to Hidden = False



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
Open file Slow on Excel 2003 Vuka Excel Discussion (Misc queries) 0 March 17th 05 05:19 AM
Open txt file with more than 256 columns (how to tranpose in rows)? uriel78 Excel Discussion (Misc queries) 1 February 12th 05 02:16 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
How can I open a large Excel file with more than 65536 rows? Ted Excel Discussion (Misc queries) 1 January 13th 05 07:47 PM
Cannot open a file that Excel says is open Plodhia Excel Discussion (Misc queries) 2 December 7th 04 01:43 AM

All times are GMT +1. The time now is 02:32 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017