My Excel workbook is taking a long time to open. It has
many macros which affects the speed at which it opens.

What can I do to make it open faster.

You could try turning the calculation of its in tools, options, an
calculations change it to manual.......best if you record this as
macro and put it in the auto open perhaps along wit
Application.EnableEvents=False......don't forget to turn them back o
at the end of the auto open or in the macro you require to run afte
that.

HTH


Simo

--
Message posted from http://www.ExcelForum.com

The more expensive route would be to get a faster computer, more memory,
faster hard drive :-D

--
Toby Erkson
Oregon, USA

"pcw" wrote in message
...

My Excel workbook is taking a long time to open. It has
many macros which affects the speed at which it opens.

What can I do to make it open faster.

Try these links

http://www.decisionmodels.com/optspeedd.htm#OpSave

http://www.mvps.org/dmcritchie/excel/slowresp.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"pcw" wrote in message
...

My Excel workbook is taking a long time to open. It has
many macros which affects the speed at which it opens.

What can I do to make it open faster.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.679 / Virus Database: 441 - Release Date: 07/05/2004