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

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

Jon,

Thanks for your response. I realize I can change row and column sizes. I
was hoping maybe someone had some kind of utility to make the 2007 document
look more like the 2003 document. It's a pretty significant difference in
the way they look. This isn't actually my document. It belongs to a user
who has a number of documents in the same format. She's going to have a big
job changing them all.

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

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

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

Thanks a lot for your help with this.

"Jon Peltier" wrote:

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

I wish I had a better answer.

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


"Mary Fetsch" wrote in message
...
Thanks a lot for your help with this.

"Jon Peltier" wrote:

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

Hi there --

I'm having a similar compability problem with cell colors. I hear what
you're saying about the programs being "different," but clients want the
colors they've always had in long-used documents. Can my client contact you
directly so you can explain the differences and why they can't be fixed? :-)

Sorry for the mild sarcasm, but basic things like colors matter to people
and should be backward compatible. I wouldn't expect the more complicated
improvements do work in older programs, of course. But maybe you could add a
"2003 color palette" to the 2007 program, for instance. There must be some
relatively simple fixes for issues like this.

Thanks.

Doug Keith

"Jon Peltier" wrote:

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