Printing problems after Quattro conversion

[Libby]

At my company, we are in the process of converting a series of Quattro Pro 9
spreadsheets into Excel 2003. The conversions are reasonably successful, but
we are having one problem. The converted Excel spreadsheets want to print
numerous blank pages even if there is only a small table on one sheet. We
can't see what it is that Excel is printing. For a single page worksheet, it
will sometimes print the data and then 30 blank pages. This is happening for
many converted files, with different users on different computers.

Anyone else ever run into this? Is there a cure?

Libby

 

[Pete_UK]

The only cure I know of is to manually set the print area within Excel
for each sheet - i.e. highlight the area you want to print, click on
File | Print Area | Set Print Area. Bit tedious, but once it's done
then Excel will remember the print areas in future.

Hope this helps.

Pete

 

[dlw]

Another thing I've found that "cleans up" converted sheets, highlight
everything you want, copy, and paste it into a new sheet.

 

[Libby]

Yes, we've been using this as a workaround already. Thanks.

 

[Pete_UK]

You're welcome.

Pete

Yes, we've been using this as a workaround already.  Thanks.






- Show quoted text -