hidden rows & columns slow file open

S

Simon Shaw

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top