Excel Document of 2.5mb takes up to 20min to open up

M

Mark Mossop

Finally I have found the cure, basically it was caused by a corrupted
EMF file which used up to 100% of a CPU and the Spooler is in a never
ending loop.

Fix:

1) Do a search for *.emf files (they will be found in the Temp
directory)
2) If there are any then this is probably the cause - delete them all
3) Boot to an alternate install of NT and delete the *.shd and *.spl
file from the Spool folder.
4) If you have a multi-processor, you can pause the printer and delete
the files.

After deleting all the *.emf files, which took me almost 15min (20000
files) I tested the Excel doc and it opened up within 10 seconds as
opposed to 20-25min

Reason:

A corrupted enhanced meta file (EMF) record embedded within the print
stream can cause the Spooler to enter an infinite loop. This uses all
the CPU time for a single processor machine and prevents the print job
from completing - or in my case cause an Excel doc of approx 2.5mb,
25min to open up and causing all other apps to run very slow or hang.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top