RE: Excel 2007 not calculating margins & print area correctly

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Is the user's printer set up on their computer, or do they have the default
Jet Engine as their default printer?

"Jeff Wow" wrote:

In Excel 2007, one of our users experiences regular issues with Excel not
calculating margins & print area correctly. I’ve reviewed this user’s print
settings, and looked at the same document on my computer (where it had no
problems setting the print area correctly).

Basically, Excel is making every row a separate page. There are no page
breaks manually set, and its print settings are set to 1 page wide by
“automatic” pages tall. When I try to go into print preview, or the “margins”
tab of the print settings, I get a popup error reading “Margins do not fit
the page size”. The page size is set to 8.5”x11”, and the margins are set to
Excel’s “normal” (.75 top/bottom, .7 left/right). I’ve gone through and reset
these options multiple times.

In this document there are no macros, no unusual formulas or formatting –
it’s literally a “default” file with about 50 rows x 6 columns worth of
unformatted text data.

Any ideas or suggestions?

Thanks,
Jeff W
.



Relevant Pages

  • Re: Referal Links
    ... the source of such interference Meena's suggestion might help ... > Go to Start/Run and type in: regsvr32 urlmon.dll. ... > IE/Tools/Internet Options/Programs/Reset Web Settings. ... Thanks Jeff ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Client cant modify local Internet Options
    ... As Jeff wrote, greyed out options usually mean that a Group Policy ... has enforced the settings. ... Use Resultant Set of Policies for this user on this Terminal Server ...
    (microsoft.public.windows.terminal_services)
  • Re: RemoteAPP sessions show disconnected on server but dont log off
    ... Jeff, that was it. ... the install did not have any disconnect ... didn't know about these settings. ... Microsoft MVP - Terminal Services ...
    (microsoft.public.windows.terminal_services)
  • Re: Report Page Setup Keeps Changing Bug
    ... If you are using Access 2000 this is a known bug and is documented ... 240826 'Lost Printer Settings when Name Autocorrect is turned on' ... After that it would be wise to continue updating to Service Pack 3 ... Jeff Conrad ...
    (microsoft.public.access.reports)
  • Re: skipping double letters
    ... "Jeff" wrote: ... I've gone to the settings for the keyboard and tried different ... Repeat delay: set to closest to Short ...
    (microsoft.public.windowsxp.general)