Troubleshooting Printing & Templates

If you are having trouble with printing templates from NewViews, here are some Questions and Answers. Keep in mind that we print to any version of Excel, (97, 2000, 2002, 2003, 2007 and 2010). Newer versions of Excel have commands and settings that did not exist in prior versions.

Printing performance slow down with a new computer ...

If you upgraded to Microsoft Excel® 2007 (version 12) or 2010 (version 14) from a prior version you may have experienced a substantial performance slow down.

Excel 2007 increased the maximum number of rows per worksheet from 65,536 to over 1 million, and the number of columns from 256 (IV) to 16,384 (XFD).

Print Speedup command line option ...

NewViews has an command line option that works around the Excel 2007 or 2010 problem and templated printing should run between 1.5 and 6 times faster, depending on the complexity of the template.

The default behavior of NewViews is to run with more compatible, slower print code. The faster print code can be selected by using the command line argument -template_print_speedup.

Note: If you are using a version of Microsoft Excel prior to 2007 (version 12) you may not notice a change in performance no matter what you do.

When I print a document I get Multiple Images/Logos ...

When an Excel file .xls (printing template) is created in Excel '97 that contains an image or logo, and is then printed using Excel 2007 or 2010 you may see several duplicate copies of the image or logo.

There is a behaviour change in the newest versions of Excel. Every image has properties. One way to resolve this printing problem is:

Right click on the image and select Format Picture
Select the Properties tab
Select the Move and size with cells
Click OK to close the window
Save the file

Can't find the 7" long paper ...

If you have forms that are 7" long you may need to set your computer's print server to use 7" long forms.

In Windows XP

Open your Window's Printers and Faxes settings
In the main File menu choose Server Properties
Select the Forms tab and create a new form
Give the new form a name and specify the paper size below
Click on Save Form

In Windows Vista & 7

Open your Window's Devices and Printers settings
Select the desired printer
On the menu, select Printer Server Properties
Select the Forms tab and create a new form
Give the new form a name and specify the paper size below
Click on Save Form

The new paper size should now be available in all installed printers connected to your computer.