Re: Shrinks page to be printed

From: David DeRolph (dderolph_at_earthlink.net)
Date: 09/18/04 

Date: Fri, 17 Sep 2004 23:42:33 -0400

Well, I have a different picture now of the situation, as far as the users
are concerned. Now I know they are clients, not employees.

I have one more suggestion. Those users that have the problem with how the
work*** prints, due to a larger area than the area containing the data
being selected, apparently have some settings or preferences "sticking" from
working with certain files in the past. I suggest that they delete their
personal.xls file and let Excel create a new one. Now, they need to be
aware that they will lose any custom settings for preferences, menus,
toolbars, etc. will be lost by doing this. I believe this can cause macros
to be lost, also. This might be helpful:
http://www.meadinkent.co.uk/xlconfigure.htm.

"jgranda" <jgranda@discussions.microsoft.com> wrote in message
news:FBE60601-5B21-4092-B4BA-33E9C56A6D0B@microsoft.com...
> Actually this spread could be on a network or on their local desktop. As
a
> little background, there is an enterprise solution that sits most likely
on a
> server. It generates a file and most likely is opened up on a desktop
using
> the Excel on the users desktop. In other words, it is a flat file being
> exported to users.
>
> The users of this Excel spread*** work for different firms so they are
on
> different networks.
>
> As for explaining to the users how to select, I can do that but I was
hoping
> for a simpler remedy. The reason being is there are 12 sheets in each
> spreadsheet and a user might create more than one of these spreadsheets a
> day. Imagine how many times they will have to select to print out the
> sheets. We are trying to provide our clients with effiicient and time
> savings solutions and that would not necessarily be terribly efficient.
My
> alternative will have to be to write additional VB code which I was trying
to
> avoid for the selection process.
>
> Thanks for your help.
>
> Joe
>
> "David DeRolph" wrote:
>
> > All these users are on a network, right? And, they open this file from
a
> > server, right? But, each machine has Excel installed on it, right? In
such
> > a situation, I'm not sure, when opening an Excel file via the network
and
> > printing that file, whether Excel uses settings embedded in that file,
or
> > settings in that particular computer's settings for Excel. If the
latter,
> > then that could explain why those two users are getting different
results.
> > Do you agree?
> > And, if this is the case, then maybe the problem can be resolved by
simply
> > providing some instruction to those users about how to select the range
to
> > be printed before printing.
> > "jgranda" <jgranda@discussions.microsoft.com> wrote in message
> > news:5429EA39-8066-4FBB-831E-F4B2CDDB6C20@microsoft.com...
> > > Scaling is not the issue. They have the identical scaling as I do.
It is
> > > set to scale to fit to page. I had a chance to look at the
spread***
> > while
> > > on one of the computers in question. The spread*** does not have
"Print
> > > Area" selected so it should automatically select the area for
printing.
> > For
> > > my spread*** for instance, it looks like it is selecting A1:H80
> > > (approximately). Hers looks like it is selecting something
significantly
> > > larger which is why it looks so small when scaled to fit the page.
> > >
> > > Why would one computer select the print area differently than another?
Is
> > > there a setting that can be adjusted so they do it similarly?
> > >
> > > Remember I can not preset the the Print Area because each spread***
can
> > > vary slightly.
> > >
> > > Thanks!
> > >
> > > Joe
> > >
> > >
> > > "dderolph >" wrote:
> > >
> > > > Sounds like they may have Scaling set at a small percentage. This
> > > > setting is found under Page Setup, on the File menu. The Page Setup
> > > > panel has four tabs. On the Page tab is a setting called Scaling.
I
> > > > believe 100% is the normal setting. Changing that to a lower
setting
> > > > will cause the print to be smaller. For example, a setting of 50%
> > > > prints characters half the normal size, which is quite tiny for
> > > > reading.
> > > >
> > > >
> > > > ---
> > > > Message posted from http://www.ExcelForum.com/
> > > >
> > > >
> >
> >
> >