Thread: Wookbook speed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Wookbook speed

I have created a workbook that is 13 mb. It contains about 25 pages and 50
or so macros. When I open more than one of these workbooks and go to
recalculate it the process takes about 5 minutes. If I only have one big
open it will take 10 seconds.

How can I make this workbook run faster when more that one book is open? I
am currently using this on 13 computers and each one has a 1gig of Ram and
using windows 2000.

If anyone could help I would be very thankful.

Eric