Excel Printer Windows Freezes?

Question

Hi, I have many excel sheet that Print to a network printer. Everytime I try printing multiple worksheet, it says sending to printer and when it hits page 6 of 14 or 8 of 14 or 11 of 14 at random it freezes and nothing prints and I have to force clsoe excel. Any ideas? I tried different print drivers too

Answer 1

Try printing in small batches. Print a small amount of worksheets at a time. If it is a networked printer, the printer might be running out of memory before your job can be completely spooled to it.