Doc takes too long to open

[andy62]

I've tried various remedies from this board but am still needing to reduce
the time my doc (Word 2003) takes to open. I have tried the "Maggie
Transformation" (copy all but last paragraph mark to a clean doc); that
helped but is still leaving me with ~25 seconds to open the doc. The file
size is only 235K, but I have some code that may be slowing things down:
- One very short / quick macro
- One keyboard shortcut that is stored in the document (not the normal
template)
- About 32 checkboxes

The file is not a locked form or a template, it's just a regular doc with
the code described above. Users' macro security is set to low (not my idea,
but helpful not to have to tell them to "enable macros" on the way in). I
just can't think of anything else to do to speed up the time to open. Any
ideas?

TIA.

 

[Jan Hyde (VB MVP)]

andy62 <[email protected]>'s wild thoughts
were released on Mon, 20 Oct 2008 09:09:01 -0700 bearing the
following fruit:

I've tried various remedies from this board but am still needing to reduce
the time my doc (Word 2003) takes to open. I have tried the "Maggie
Transformation" (copy all but last paragraph mark to a clean doc); that
helped but is still leaving me with ~25 seconds to open the doc. The file
size is only 235K, but I have some code that may be slowing things down:
- One very short / quick macro
- One keyboard shortcut that is stored in the document (not the normal
template)
- About 32 checkboxes

The file is not a locked form or a template, it's just a regular doc with
the code described above. Users' macro security is set to low (not my idea,
but helpful not to have to tell them to "enable macros" on the way in). I
just can't think of anything else to do to speed up the time to open. Any
ideas?

Does it have any links in it?

 

[andy62]

Nolinks, just the VBA code I listed.

andy62 <[email protected]>'s wild thoughts
were released on Mon, 20 Oct 2008 09:09:01 -0700 bearing the
following fruit:


Does it have any links in it?

 

[Paul W]

I have the exact same problem and cannot find a way to speed up the opening time. I have very similar content to what you describe and it takes about 28 seconds to open.

Have you come across a soltion?