Error message when you try to print from Excel 2010: "Microsoft Excel has encountered a problem and needs to close"

Method 1: Try to use a different printer driver as your default printer driver

1. Open the Add Printer dialog box:

   1. In Windows Vista: Click Start, and then click Printers.
      
      In Windows 7: Click Start, and then click Devices and Printers.

   2. Click Add a printer.

2. Add a new printer:

   1. In the Add Printer dialog box, click Add a local printer.

   2. Click Use an existing port, and then click Next.

   3. In the Manufacturer list, click Microsoft.

   4. Click Microsoft XPS Document Writer, and then click Next.

   5. Click Use the driver that is currently installed (recommended), and then click Next.

   6. Click to select the Set as the default printer check box, and then click Next.

   7. Click Finish.

3. Verify that changing printer drivers fixes the problem:

   1. Open a spreadsheet in Excel 2010.

   2. Click File, click the Print tab, and then click the Print icon.

4. If this does not resolve the problem, try to use Method 2.

Method 2: Update your printer driver

Contact the printer manufacturer for drivers and instructions.