The only way to keep the document fully compatible with Excel 2003 is to
only use Excel 2003. Between Excel 97 and 2003, four versions of Excel, and
probably even one or two versions prior, there were only minor changes to
the appearance of your workbooks. There are a lot of changes, major and
minor, to Excel 2007, and a great many of them affect document appearance,
even when colors and cell dimensions are nominally the same. You are not
missing a setting. It just works differently.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mary Fetsch" wrote in message
...
Jon,

I was just reminded that we've been through several Excel upgrades and
have
not had this problem until Excel 2007. We've specified that our documents
should be saved as type "Excel 97-2003 Workbook" which is described as
"fully
compatible with Excel 97-2003". It's obviously not fully compatible. I
first thought it might be a printer driver problem, but I'm getting the
same
results on 2 diferent printers. Is there possibly some setting we're
missing
in 2007? Or is 2007 just doing scaling differently than 2003, and we have
to
live with it?

Mary

"Jon Peltier" wrote:

Well, you could change the row and column sizes so it prints the way you
want. You will encounter various issues (including distortion) when you
use
Excel at less than 100% screen view, and it is not unreasonable to find
that
the relative distortion in 2007 does not match that in 2003.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mary Fetsch" wrote in message
...
I have an Excel 2003 document with scaling adjusted to 45% of normal
size.
When I print it in Excel 2007, my columns are wider than in 2003, and
my
rows
are closer together. This is causing major problems with extra pages
and
pages breaking in the wrong places. Is there any fix for this?

Mary Fetsch