Excel 2007 - A3 or 11x17 page size

L

LouP

I use 11x17 ( inches ) or the A3 format alot at work. My Excel 2007 doesn't
have that size available, how do I get that size of page?
 
D

Dave Peterson

Isn't this a feature of what printer you're using?

Make sure you're printer supports 11x17.
 
J

Jim Rech

I just clicked the Size menu on the Page Layout tab and A3 was the 4th item
listed. And it's not because I have a printer that supports that paper size
available, so I'd think this is standard.
 
D

Dave Peterson

Well, you made me start up VPC again <vbg>.

The 11x17 (or tabloid) shows up for me. But the only "printers" I have
installed are the MS document Image write and Image writer.

I wonder if having those makes a difference.
 
J

Jim Rech

I wonder if having those makes a difference.

The question is, does Excel query your print drivers to see what paper sizes
they support? I think that's very unlikely. It would be slow especially if
you have a lot of printers installed, which you could on a corporate
network. Or maybe you want to set up to print on another machine?

So why didn't LouP see this paper size? Maybe he just missed it? LouP?

--
Jim
| Well, you made me start up VPC again <vbg>.
|
| The 11x17 (or tabloid) shows up for me. But the only "printers" I have
| installed are the MS document Image write and Image writer.
|
| I wonder if having those makes a difference.
|
|
|
| Jim Rech wrote:
| >
| > I just clicked the Size menu on the Page Layout tab and A3 was the 4th
item
| > listed. And it's not because I have a printer that supports that paper
size
| > available, so I'd think this is standard.
| >
| > --
| > Jim
| > | > |I use 11x17 ( inches ) or the A3 format alot at work. My Excel 2007
doesn't
| > | have that size available, how do I get that size of page?
|
| --
|
| Dave Peterson
 
L

LouP

Thanks Jim and Dave,

You were both onto something, I selected the Microsoft XPS Document Writer
as my default printer, I'm just using a Brother MFC 420CN currently, and when
I checked the Page Layout - Size, I had more options and A3 and 11x17 were
both there.

Thanks, LouP
 
J

Jim Rech

When I switched to the XPS printer I had many more choices in the drop down
than I did with my physical printer. So, whether Excel is querying the
driver or reading a list of supported paper sizes from the registry or
somewhere else, the list does seem to be dynamic. So I was wrong, Dave. I
think that's the first time! ;-)

--
Jim
| Thanks Jim and Dave,
|
| You were both onto something, I selected the Microsoft XPS Document Writer
| as my default printer, I'm just using a Brother MFC 420CN currently, and
when
| I checked the Page Layout - Size, I had more options and A3 and 11x17 were
| both there.
|
| Thanks, LouP
|
| "Dave Peterson" wrote:
|
| > Well, you made me start up VPC again <vbg>.
| >
| > The 11x17 (or tabloid) shows up for me. But the only "printers" I have
| > installed are the MS document Image write and Image writer.
| >
| > I wonder if having those makes a difference.
| >
| >
| >
| > Jim Rech wrote:
| > >
| > > I just clicked the Size menu on the Page Layout tab and A3 was the 4th
item
| > > listed. And it's not because I have a printer that supports that
paper size
| > > available, so I'd think this is standard.
| > >
| > > --
| > > Jim
| > > | > > |I use 11x17 ( inches ) or the A3 format alot at work. My Excel 2007
doesn't
| > > | have that size available, how do I get that size of page?
| >
| > --
| >
| > Dave Peterson
| >
 
D

Dave Peterson

Weren't you wrong before--when you thought you were wrong, but actually you were
right???

(yeah, it's an old joke, but I'm an old guy!)
 
M

MartinW

Hi Jim and Dave,

All the printers info is stored in the driver file. The driver also supplies
the formatting style of the Print dialog box. Every time you change printers
the program and the printer re-introduce themselves to each other as if for
the
first time. The driver is like an owners manual that details every part of
the printer including things like paper size and printable area etc.

You can see this happening by having a program open on your screen, we'll
use Excel, but any program will do. With Excel open and maximised
go to Start>Settings>Printers and Faxes and right click on a non default
printer and then click on Set as default Printer. As you click on it make
sure you are looking at the Excel screen and you will see an almost
imperceptible blink. That blink is the entire conversation. This same
conversation happens with each new program as it is started.

A better visual demonstration can be seen by doing Ctrl+Alt+Del to bring
up the Windows Task Manager and click on the Performance tab. Now change
your default printer backwards and forwards and you will see the CPU usage
graph
spiking each time there is a change.

The info is only ever permanently stored in the driver file. Each program
will store
the information temporarily but will drop it as soon as it closes or, as in
the example
above, when the default printer is changed. When you re-open a program the
default
printer introduces itself again, kind of like Groundhog Day I guess. <g>

Regards
Martin
 
J

Jim Rech

Interesting. Thanks, Martin.

--
Jim
MartinW said:
Hi Jim and Dave,

All the printers info is stored in the driver file. The driver also
supplies
the formatting style of the Print dialog box. Every time you change
printers
the program and the printer re-introduce themselves to each other as if
for the
first time. The driver is like an owners manual that details every part of
the printer including things like paper size and printable area etc.

You can see this happening by having a program open on your screen, we'll
use Excel, but any program will do. With Excel open and maximised
go to Start>Settings>Printers and Faxes and right click on a non default
printer and then click on Set as default Printer. As you click on it make
sure you are looking at the Excel screen and you will see an almost
imperceptible blink. That blink is the entire conversation. This same
conversation happens with each new program as it is started.

A better visual demonstration can be seen by doing Ctrl+Alt+Del to bring
up the Windows Task Manager and click on the Performance tab. Now change
your default printer backwards and forwards and you will see the CPU usage
graph
spiking each time there is a change.

The info is only ever permanently stored in the driver file. Each program
will store
the information temporarily but will drop it as soon as it closes or, as
in the example
above, when the default printer is changed. When you re-open a program the
default
printer introduces itself again, kind of like Groundhog Day I guess. <g>

Regards
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top