Hi!
I have made a chart that I want to print out in several copies for exemple 4
copies.
But instead of making one file and doing 4 copies Excel makes 4 files and 1
copy per file and send this to the printer. Is there any way to fix this?

When simply printing, Excel should not create any files.

How are you calling the print job?


Gord Dibben MS Excel MVP

On Thu, 20 Aug 2009 02:40:05 -0700, vito
wrote:

Hi!
I have made a chart that I want to print out in several copies for exemple 4
copies.
But instead of making one file and doing 4 copies Excel makes 4 files and 1
copy per file and send this to the printer. Is there any way to fix this?

vito wrote:
Hi!
I have made a chart that I want to print out in several copies for exemple 4
copies.
But instead of making one file and doing 4 copies Excel makes 4 files and 1
copy per file and send this to the printer. Is there any way to fix this?

"makes 4 files" ??? Printing from Excel should not make 4 files. What
are the files' names?

Is your chart on a separate worksheet?

In Excel Ctrl-P should call up the print dialog box where you can select
4 copies of your chart to print.

Bill

It actually not files but printingjobs. So instead of making one printingjob
with 4 copies Excel makes 4 printingjobs with one copy.

"Bill Sharpe" skrev:

vito wrote:
Hi!
I have made a chart that I want to print out in several copies for exemple 4
copies.
But instead of making one file and doing 4 copies Excel makes 4 files and 1
copy per file and send this to the printer. Is there any way to fix this?

"makes 4 files" ??? Printing from Excel should not make 4 files. What
are the files' names?

Is your chart on a separate worksheet?

In Excel Ctrl-P should call up the print dialog box where you can select
4 copies of your chart to print.

Bill

vito wrote:
It actually not files but printingjobs. So instead of making one printingjob
with 4 copies Excel makes 4 printingjobs with one copy.


OK, but do you get four charts printed out? If so, what is the problem?

The problem is that it takes longer time to print out this way.
In Word for example when you print out it create one printing job and the
number of copies that you want. It's a much faster way.


"Bill Sharpe" skrev:

vito wrote:
It actually not files but printingjobs. So instead of making one printingjob
with 4 copies Excel makes 4 printingjobs with one copy.


OK, but do you get four charts printed out? If so, what is the problem?

vito wrote:
The problem is that it takes longer time to print out this way.
In Word for example when you print out it create one printing job and the
number of copies that you want. It's a much faster way.


"Bill Sharpe" skrev:

vito wrote:
It actually not files but printingjobs. So instead of making one printingjob
with 4 copies Excel makes 4 printingjobs with one copy.

OK, but do you get four charts printed out? If so, what is the problem?


Graphics, which is what a chart is, generally take longer to print than
text.

If still a concern, Google for updated printer drivers for your brand of
printer.

If all else fails, just go have a cup of coffee while printing these
charts...

Bill