Re: Excel Workbook slow to open

Sandy
The size of the file controls how long it takes to open the file. The
size of the file is controlled by, among other things, what Excel thinks is
the used range of each ***. Let's say that you type something in A1 and
something in IV12000. You have only 2 entries in the entire ***. Excel
thinks the used range is A1:IV12000. That is not a small used range. If
you had put the entries in A1 and B2, Excel would think the used range was
A1:B2. That is a small used range. Yes, those 12,700 blank rows that he
has would significantly increase the size of the file and the time it takes
to open.
Be advised that if he eliminates all those blank rows, Excel may still
think the used range is what it was before. He will need to delete all the
rows and columns after his real last used cell. Post back for more
information on this if you need it. HTH Otto
"Sandy M" <SandyM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C392932E-3FD6-4ED9-A31B-B416FBAC5E26@xxxxxxxxxxxxxxxx
> One of our guys created a workbook that takes about 3 minutes to open.
>
> It has about 12,700 blank lines and he has it protected so that people
> can't change it.
>
> Would this cause it to take a long time to open?
>
> What you recommend that he do to speed it up?
>
> Thanks,
>
> Sandy M


.