MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Taking a long time to open a workbook


Posted by Paul Blakeney on July 29, 2001 12:15 PM

I am designing a spreadsheet that is around 40 MB so far. It takes about 15 minutes to open the workbook. I notice during this time of opening the workbook, at the bottom of the workbook a message appears that reads "requesting virus scan", when the message disappears, the workbook opens. I presume that the reason that it takes so long to open is because the entire workbook is scanned for viruses. If this is true how do you get around this, or what other tips do you know about for making it take less time to open the workbook. Thanks for the help. Paul B.


Posted by Ian on July 29, 2001 3:00 PM

What's in your workbook??
that's a hugh file.
lots of links'll will be tiresome for starters, images, etc.
you need to look and see if you can cut down on some things. Being ex-graphic design I know lots of people have massive image sizes which are NOT nessesary, if you have them, you don't need CMYK and 72 dpi will do for most black and white printing. Trim down your formulas?? do you need all the links? do they update all the time? could you paste special values with any of them?

but re: virus scanning, if your on a network, you'll be hard pushed to get any administrator to take that off.

Ian

Posted by Rob on July 30, 2001 1:10 AM


How much of this is data and how much is later manipulation? Could some of this manipulation be done with code? Try and avoid if statements, they take alot of time. Try using Match and Offset instead with a logical solver. eg: instead of =IF(a=b,c,0) try =(a=b)*c

Other options are switching off the calculation until required. Using multiple workbooks. Consolidation to transfer data without opening workbooks. Or simply going straight for a database.

Rob

Posted by Rob on July 30, 2001 1:10 AM


How much of this is data and how much is later manipulation? Could some of this manipulation be done with code? Try and avoid if statements, they take alot of time. Try using Match and Offset instead with a logical solver. eg: instead of =IF(a=b,c,0) try =(a=b)*c

Other options are switching off the calculation until required. Using multiple workbooks. Consolidation to transfer data without opening workbooks. Or simply going straight for a database.

Rob