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, 2010 and 2013). 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.

See Command Line Options for more on running NewViews with command line control switches. Please try your templates with the faster printing turned on and report any problems to Q.W. Page.

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.

Error 0x800a03ec or other number

This is most commonly caused by Excel not running properly. Check your processes in the Windows task manager and see if Excel is listed. If Excel did not shut down fully/properly, a process stub may be left in memory. If you do not see any evidence of Excel on the desktop or in the Window's Taskbar, use End Task to terminate Excel from the task manager.

After terminating Excel, shut down NewViews with Alt-X and restart NewViews.

We have also seen similar error messages when more than one copy of Excel is installed on the same computer.

Error 0x80020005 {Type mismatch,}

This is most commonly caused by not having the correct default printer set. Check under Devices and Printers, see if the correct printer is the default. If the Excel template you are printing does not fit the paper size on the default printer it may put up this error.

Change the default printer in Windows to match the correct printer you wish to print to.

When I print a check it prints on two pages ...

The various versions of Excel have different default margins sizes and scaling options. Open the template file with Excel.

set the margins

We recommend setting the check margins (top, bottom, left, right, header & footer) to zero or minimum. After you have adjusted the margins, save the template file and try reprinting the check to plain paper. If it still prints more than one page, adjust the scaling.
set the scaling

Under the scaling options, do NOT use fit to 1 page(s) wide by 1 tall. Use the adjust to: 100% normal size options to shrink the template if the check does not fit on one page with 0 margins. Adjust the 100% to 95%, save the template file and try printing again, if it still prints more than one page, try 90%.

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 dot matrix 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.

Unable to Set the rowheight property of the range ...

The Excel Page Setup properties has a section on Scaling. Verify that the scaling is set to % normal size, if it is set to Fit to: 1 pages(s) wide by 1 tall you may get the error message.