ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing problems after Quattro conversion (https://www.excelbanter.com/excel-discussion-misc-queries/172263-printing-problems-after-quattro-conversion.html)

Libby

Printing problems after Quattro conversion
 
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

Printing problems after Quattro conversion
 
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

On Jan 9, 2:40*pm, Libby wrote:
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



dlw

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

"Libby" wrote:

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


Libby

Printing problems after Quattro conversion
 
Yes, we've been using this as a workaround already. Thanks.

"Pete_UK" wrote:

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

On Jan 9, 2:40 pm, Libby wrote:
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

Printing problems after Quattro conversion
 
You're welcome.

Pete

On Jan 9, 3:36*pm, Libby wrote:
Yes, we've been using this as a workaround already. *Thanks.



"Pete_UK" wrote:
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


On Jan 9, 2:40 pm, Libby wrote:
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- Hide quoted text -


- Show quoted text -




All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com