Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
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 Thanks Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open file Slow on Excel 2003 | Excel Discussion (Misc queries) | |||
Open txt file with more than 256 columns (how to tranpose in rows)? | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How can I open a large Excel file with more than 65536 rows? | Excel Discussion (Misc queries) | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) |