no zoom in print preview on a landscape-oriented page

I'm stumped. The option to zoom is not available when viewing a worksheet in
print preview. This seems to occur on all landscaped sheets. Portrait
worksheets are not effected.
Is there a fix? Anyone? Found only one other guy on the web asking the
same question in various forums - no one responded to him.
Thanks.

Cannot replicate this behaviour with Excel 2003.

Could it be a printer driver problem?


Gord Dibben MS Excel MVP

On Thu, 16 Oct 2008 07:57:01 -0700, PS <> wrote:

>I'm stumped. The option to zoom is not available when viewing a worksheet in
>print preview. This seems to occur on all landscaped sheets. Portrait
>worksheets are not effected.
>Is there a fix? Anyone? Found only one other guy on the web asking the
>same question in various forums - no one responded to him.
>Thanks.

Hey, Gord, thanks for suggestion.

I have a little more information based on my troubleshooting. I'm thinking
it has
something to do w/resolution. Mine is 1680 x 1050, as are most of the
monitors here, varying slightly based on 22" size or 19" size monitor.
However, on one of the std CRT displays set to 1024 x 768, the issue doesn't
exist.
Any clues based on that?


"Gord Dibben" wrote:

> Cannot replicate this behaviour with Excel 2003.
>
> Could it be a printer driver problem?
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 16 Oct 2008 07:57:01 -0700, PS <> wrote:
>
> >I'm stumped. The option to zoom is not available when viewing a worksheet in
> >print preview. This seems to occur on all landscaped sheets. Portrait
> >worksheets are not effected.
> >Is there a fix? Anyone? Found only one other guy on the web asking the
> >same question in various forums - no one responded to him.
> >Thanks.
>
>

No clues from this writer.

I don't have the hardware to test upon.

I see you got a reply to your post in another news group.


Gord

On Thu, 16 Oct 2008 10:12:01 -0700, PS <> wrote:

>Hey, Gord, thanks for suggestion.
>
>I have a little more information based on my troubleshooting. I'm thinking
>it has
>something to do w/resolution. Mine is 1680 x 1050, as are most of the
>monitors here, varying slightly based on 22" size or 19" size monitor.
>However, on one of the std CRT displays set to 1024 x 768, the issue doesn't
>exist.
>Any clues based on that?
>
>
>"Gord Dibben" wrote:
>
>> Cannot replicate this behaviour with Excel 2003.
>>
>> Could it be a printer driver problem?
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Thu, 16 Oct 2008 07:57:01 -0700, PS <> wrote:
>>
>> >I'm stumped. The option to zoom is not available when viewing a worksheet in
>> >print preview. This seems to occur on all landscaped sheets. Portrait
>> >worksheets are not effected.
>> >Is there a fix? Anyone? Found only one other guy on the web asking the
>> >same question in various forums - no one responded to him.
>> >Thanks.
>>
>>

Hi,

Most print preview problems turn out to be caused by printer drivers. To
test this take the file to machine connected to a different kind of printer
and see if the problem persists.

--
Thanks,
Shane Devenshire


"PS" wrote:

> I'm stumped. The option to zoom is not available when viewing a worksheet in
> print preview. This seems to occur on all landscaped sheets. Portrait
> worksheets are not effected.
> Is there a fix? Anyone? Found only one other guy on the web asking the
> same question in various forums - no one responded to him.
> Thanks.

Hey, Shane, thank you for your suggestion.

However, further investigation definitely indicates is has something to do
with the resolution - or window size, I should say.

When I resize the window down, the zoom button in print preview becomes
available. I would think if it had to do with the printer, it would remain
disabled regardless.

Also, I've tried the spreadsheet on several machines all with fully
functioning, differing printers and it is only the computers with large
monitors that cannot zoom in print preview. Weirdness.

I know there has to be a workaround, I don't want to have to write a macro
to reset the resolution each time the workbook is opened and closed. If you
think of anything else, I am obviously still without a "resolution", pardon
the pun, so I am open to suggestions.

Thanks, again.

P.

"ShaneDevenshire" wrote:

> Hi,
>
> Most print preview problems turn out to be caused by printer drivers. To
> test this take the file to machine connected to a different kind of printer
> and see if the problem persists.
>
> --
> Thanks,
> Shane Devenshire
>
>
> "PS" wrote:
>
> > I'm stumped. The option to zoom is not available when viewing a worksheet in
> > print preview. This seems to occur on all landscaped sheets. Portrait
> > worksheets are not effected.
> > Is there a fix? Anyone? Found only one other guy on the web asking the
> > same question in various forums - no one responded to him.
> > Thanks.

Hi,

I don't have any more suggestions but if you can let me know the name and
type etc of the monitor I will pass the bug, and that's what it sounds like
on to Microsoft.

--
Thanks,
Shane Devenshire


"PS" wrote:

> Hey, Shane, thank you for your suggestion.
>
> However, further investigation definitely indicates is has something to do
> with the resolution - or window size, I should say.
>
> When I resize the window down, the zoom button in print preview becomes
> available. I would think if it had to do with the printer, it would remain
> disabled regardless.
>
> Also, I've tried the spreadsheet on several machines all with fully
> functioning, differing printers and it is only the computers with large
> monitors that cannot zoom in print preview. Weirdness.
>
> I know there has to be a workaround, I don't want to have to write a macro
> to reset the resolution each time the workbook is opened and closed. If you
> think of anything else, I am obviously still without a "resolution", pardon
> the pun, so I am open to suggestions.
>
> Thanks, again.
>
> P.
>
> "ShaneDevenshire" wrote:
>
> > Hi,
> >
> > Most print preview problems turn out to be caused by printer drivers. To
> > test this take the file to machine connected to a different kind of printer
> > and see if the problem persists.
> >
> > --
> > Thanks,
> > Shane Devenshire
> >
> >
> > "PS" wrote:
> >
> > > I'm stumped. The option to zoom is not available when viewing a worksheet in
> > > print preview. This seems to occur on all landscaped sheets. Portrait
> > > worksheets are not effected.
> > > Is there a fix? Anyone? Found only one other guy on the web asking the
> > > same question in various forums - no one responded to him.
> > > Thanks.

Thanks, again, Shane. The monitors are all Dell's: two 22" wide panels,
models 2208FP and E228FP and one 19" wide panel, 1905FP.

During my troubleshooting I read something about designing your speadsheet
for the resolution it will be used in. Do you know if there is any merit in
this? I ask because when I bring the window size down to about what it was
probably created in (17"), the zoom button becomes enabled. A couple of guys
(Mr. Excel's website, perhaps) even had macros written to change the
resolution when the sheet was opened and closed, if necessary. I thought
that was a little extreme, but maybe there is something to it based on my own
experience.

Thanks again for all your help and responding back.

Take care,
P.

"ShaneDevenshire" wrote:

> Hi,
>
> I don't have any more suggestions but if you can let me know the name and
> type etc of the monitor I will pass the bug, and that's what it sounds like
> on to Microsoft.
>
> --
> Thanks,
> Shane Devenshire
>
>
> "PS" wrote:
>
> > Hey, Shane, thank you for your suggestion.
> >
> > However, further investigation definitely indicates is has something to do
> > with the resolution - or window size, I should say.
> >
> > When I resize the window down, the zoom button in print preview becomes
> > available. I would think if it had to do with the printer, it would remain
> > disabled regardless.
> >
> > Also, I've tried the spreadsheet on several machines all with fully
> > functioning, differing printers and it is only the computers with large
> > monitors that cannot zoom in print preview. Weirdness.
> >
> > I know there has to be a workaround, I don't want to have to write a macro
> > to reset the resolution each time the workbook is opened and closed. If you
> > think of anything else, I am obviously still without a "resolution", pardon
> > the pun, so I am open to suggestions.
> >
> > Thanks, again.
> >
> > P.
> >
> > "ShaneDevenshire" wrote:
> >
> > > Hi,
> > >
> > > Most print preview problems turn out to be caused by printer drivers. To
> > > test this take the file to machine connected to a different kind of printer
> > > and see if the problem persists.
> > >
> > > --
> > > Thanks,
> > > Shane Devenshire
> > >
> > >
> > > "PS" wrote:
> > >
> > > > I'm stumped. The option to zoom is not available when viewing a worksheet in
> > > > print preview. This seems to occur on all landscaped sheets. Portrait
> > > > worksheets are not effected.
> > > > Is there a fix? Anyone? Found only one other guy on the web asking the
> > > > same question in various forums - no one responded to him.
> > > > Thanks.

Hi,

Well there may be reasons to change a monitors resolution but things should
still work at the different resolutions. Regarding designing the spreadsheet
at the resolution you are going to use it at, well that nice but of no
significance to this problem. For example, if you write VBA code to display
a dialog box and position that dialog box on screen at the center of a
1800x1600 res. screen and then you hand it off to a user with a 800x600
screen, when they run the macro the dialog box comes up OFF screen, they
can't see it. I suspect that's part of what they are talking about here.

--
Thanks,
Shane Devenshire


"PS" wrote:

> Thanks, again, Shane. The monitors are all Dell's: two 22" wide panels,
> models 2208FP and E228FP and one 19" wide panel, 1905FP.
>
> During my troubleshooting I read something about designing your speadsheet
> for the resolution it will be used in. Do you know if there is any merit in
> this? I ask because when I bring the window size down to about what it was
> probably created in (17"), the zoom button becomes enabled. A couple of guys
> (Mr. Excel's website, perhaps) even had macros written to change the
> resolution when the sheet was opened and closed, if necessary. I thought
> that was a little extreme, but maybe there is something to it based on my own
> experience.
>
> Thanks again for all your help and responding back.
>
> Take care,
> P.
>
> "ShaneDevenshire" wrote:
>
> > Hi,
> >
> > I don't have any more suggestions but if you can let me know the name and
> > type etc of the monitor I will pass the bug, and that's what it sounds like
> > on to Microsoft.
> >
> > --
> > Thanks,
> > Shane Devenshire
> >
> >
> > "PS" wrote:
> >
> > > Hey, Shane, thank you for your suggestion.
> > >
> > > However, further investigation definitely indicates is has something to do
> > > with the resolution - or window size, I should say.
> > >
> > > When I resize the window down, the zoom button in print preview becomes
> > > available. I would think if it had to do with the printer, it would remain
> > > disabled regardless.
> > >
> > > Also, I've tried the spreadsheet on several machines all with fully
> > > functioning, differing printers and it is only the computers with large
> > > monitors that cannot zoom in print preview. Weirdness.
> > >
> > > I know there has to be a workaround, I don't want to have to write a macro
> > > to reset the resolution each time the workbook is opened and closed. If you
> > > think of anything else, I am obviously still without a "resolution", pardon
> > > the pun, so I am open to suggestions.
> > >
> > > Thanks, again.
> > >
> > > P.
> > >
> > > "ShaneDevenshire" wrote:
> > >
> > > > Hi,
> > > >
> > > > Most print preview problems turn out to be caused by printer drivers. To
> > > > test this take the file to machine connected to a different kind of printer
> > > > and see if the problem persists.
> > > >
> > > > --
> > > > Thanks,
> > > > Shane Devenshire
> > > >
> > > >
> > > > "PS" wrote:
> > > >
> > > > > I'm stumped. The option to zoom is not available when viewing a worksheet in
> > > > > print preview. This seems to occur on all landscaped sheets. Portrait
> > > > > worksheets are not effected.
> > > > > Is there a fix? Anyone? Found only one other guy on the web asking the
> > > > > same question in various forums - no one responded to him.
> > > > > Thanks.

Hey, Shane;

I got it. What you explain here makes sense to me now, relative to the
macro to adjust the resolution.

Do you think uninstalling/reinstalling would have any effect? The larger
size monitors are upgrades; these computers did not always operate with 19+"
screens. I ran repair just as a precaution, but that did not resolve it.

Thanks again for all your help.

"ShaneDevenshire" wrote:

> Hi,
>
> Well there may be reasons to change a monitors resolution but things should
> still work at the different resolutions. Regarding designing the spreadsheet
> at the resolution you are going to use it at, well that nice but of no
> significance to this problem. For example, if you write VBA code to display
> a dialog box and position that dialog box on screen at the center of a
> 1800x1600 res. screen and then you hand it off to a user with a 800x600
> screen, when they run the macro the dialog box comes up OFF screen, they
> can't see it. I suspect that's part of what they are talking about here.
>
> --
> Thanks,
> Shane Devenshire
>
>
> "PS" wrote:
>
> > Thanks, again, Shane. The monitors are all Dell's: two 22" wide panels,
> > models 2208FP and E228FP and one 19" wide panel, 1905FP.
> >
> > During my troubleshooting I read something about designing your speadsheet
> > for the resolution it will be used in. Do you know if there is any merit in
> > this? I ask because when I bring the window size down to about what it was
> > probably created in (17"), the zoom button becomes enabled. A couple of guys
> > (Mr. Excel's website, perhaps) even had macros written to change the
> > resolution when the sheet was opened and closed, if necessary. I thought
> > that was a little extreme, but maybe there is something to it based on my own
> > experience.
> >
> > Thanks again for all your help and responding back.
> >
> > Take care,
> > P.
> >
> > "ShaneDevenshire" wrote:
> >
> > > Hi,
> > >
> > > I don't have any more suggestions but if you can let me know the name and
> > > type etc of the monitor I will pass the bug, and that's what it sounds like
> > > on to Microsoft.
> > >
> > > --
> > > Thanks,
> > > Shane Devenshire
> > >
> > >
> > > "PS" wrote:
> > >
> > > > Hey, Shane, thank you for your suggestion.
> > > >
> > > > However, further investigation definitely indicates is has something to do
> > > > with the resolution - or window size, I should say.
> > > >
> > > > When I resize the window down, the zoom button in print preview becomes
> > > > available. I would think if it had to do with the printer, it would remain
> > > > disabled regardless.
> > > >
> > > > Also, I've tried the spreadsheet on several machines all with fully
> > > > functioning, differing printers and it is only the computers with large
> > > > monitors that cannot zoom in print preview. Weirdness.
> > > >
> > > > I know there has to be a workaround, I don't want to have to write a macro
> > > > to reset the resolution each time the workbook is opened and closed. If you
> > > > think of anything else, I am obviously still without a "resolution", pardon
> > > > the pun, so I am open to suggestions.
> > > >
> > > > Thanks, again.
> > > >
> > > > P.
> > > >
> > > > "ShaneDevenshire" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Most print preview problems turn out to be caused by printer drivers. To
> > > > > test this take the file to machine connected to a different kind of printer
> > > > > and see if the problem persists.
> > > > >
> > > > > --
> > > > > Thanks,
> > > > > Shane Devenshire
> > > > >
> > > > >
> > > > > "PS" wrote:
> > > > >
> > > > > > I'm stumped. The option to zoom is not available when viewing a worksheet in
> > > > > > print preview. This seems to occur on all landscaped sheets. Portrait
> > > > > > worksheets are not effected.
> > > > > > Is there a fix? Anyone? Found only one other guy on the web asking the
> > > > > > same question in various forums - no one responded to him.
> > > > > > Thanks.