2007 file saved as .xls prints wrong on computer w 2003 software
 

My customers that still use Excel 2003 are complaining that my excel 2007
files (saved as .xls) don't print correctly - one problem is the last column
on the right falls off the page (creates a new page). I increased my left and
right margins and made sure the form fit on the page but when they get it, it
still doesn't fit on the page. This only started happening when I loaded the
2007 software.
I thought if I saved it as a 2003 file, it would continut to look the same
to a 2003 Excel user.
Anyone know what to do about this problem?
Tried to reinstall 2003 but get a "can't find a source" message.

2007 file saved as .xls prints wrong on computer w 2003 software
 

Hi,

Are they using the Fit to Page option in Page Setup?

Cheers,
Shane Devenshire

"bz" wrote:

My customers that still use Excel 2003 are complaining that my excel 2007
files (saved as .xls) don't print correctly - one problem is the last column
on the right falls off the page (creates a new page). I increased my left and
right margins and made sure the form fit on the page but when they get it, it
still doesn't fit on the page. This only started happening when I loaded the
2007 software.
I thought if I saved it as a 2003 file, it would continut to look the same
to a 2003 Excel user.
Anyone know what to do about this problem?
Tried to reinstall 2003 but get a "can't find a source" message.

2007 file saved as .xls prints wrong on computer w 2003 softwa
 

The customer receives the same excel reports from me every month and the
problem started when I installed 2007. Neither of us changed printers but
that was the first thing I asked.
In the meantime I sent the file to a local computer that still has 2003 so I
could see what customer is seeing - figured out what is going on. I always
use €œautofit columns€� formatted as accounting $ so of course I did the same
thing using the 2007 version. But when I opened the file using the 2003
Excel, it lost that formatting and the columns were wider than they should
have been. So thats why my customer was complaining that the last column
didnt fit on the page.
Of course, I have no clue why it loses the formatting (autofit) but at least
I know whats happening to her. Thank you.


"Bruce Sinclair" wrote:

In article , ?B?U2hhbmUgRGV2ZW5zaGlyZQ==?= wrote:
Are they using the Fit to Page option in Page Setup?

They'll have a different printer, right ? Get them to set their
spreadsheet up how they want it to print. All printers are different (eg
printable areas) ... and I suspect this is not actually your problem, but
theirs. :)


"bz" wrote:

My customers that still use Excel 2003 are complaining that my excel 2007
files (saved as .xls) don't print correctly - one problem is the last column
on the right falls off the page (creates a new page). I increased my left and

right margins and made sure the form fit on the page but when they get it, it

still doesn't fit on the page. This only started happening when I loaded the
2007 software.
I thought if I saved it as a 2003 file, it would continut to look the same
to a 2003 Excel user.
Anyone know what to do about this problem?
Tried to reinstall 2003 but get a "can't find a source" message.

2007 file saved as .xls prints wrong on computer w 2003 software
 

In article , ?B?U2hhbmUgRGV2ZW5zaGlyZQ==?= wrote:
Are they using the Fit to Page option in Page Setup?

They'll have a different printer, right ? Get them to set their
spreadsheet up how they want it to print. All printers are different (eg
printable areas) ... and I suspect this is not actually your problem, but
theirs. :)


"bz" wrote:

My customers that still use Excel 2003 are complaining that my excel 2007
files (saved as .xls) don't print correctly - one problem is the last column
on the right falls off the page (creates a new page). I increased my left and

right margins and made sure the form fit on the page but when they get it, it

still doesn't fit on the page. This only started happening when I loaded the
2007 software.
I thought if I saved it as a 2003 file, it would continut to look the same
to a 2003 Excel user.
Anyone know what to do about this problem?
Tried to reinstall 2003 but get a "can't find a source" message.

2007 file saved as .xls prints wrong on computer w 2003 softwa
 

Thanks but you were right - the printer is normally the problem.
Actually my problem isn't fixed, I just know what's happening now and have
to do her work using 2003. I have to figure out why I can't reinstall 2003
on this computer. I'm having to do her work on an old computer. I may have
to post a new question on that if I can't get it to work.

"Bruce Sinclair" wrote:

In article , ?B?Yno=?= wrote:
The customer receives the same excel reports from me every month and the
problem started when I installed 2007. Neither of us changed printers but
that was the first thing I asked.
In the meantime I sent the file to a local computer that still has 2003 so I
could see what customer is seeing - figured out what is going on. I always
use €œautofit columns€� formatted as accounting $ so of course I did the same

thing using the 2007 version. But when I opened the file using the 2003
Excel, it lost that formatting and the columns were wider than they should
have been. So that€„¢s why my customer was complaining that the last column
didn€„¢t fit on the page.
Of course, I have no clue why it loses the formatting (autofit) but at least
I know what€„¢s happening to her. Thank you.

Sorry my suggestion wasn't useful ... but good news that the problem is
fixed. :)


"Bruce Sinclair" wrote:

In article ,
?B?U2hhbmUgRGV2ZW5zaGlyZQ==?=
wrote:
Are they using the Fit to Page option in Page Setup?

They'll have a different printer, right ? Get them to set their
spreadsheet up how they want it to print. All printers are different (eg
printable areas) ... and I suspect this is not actually your problem, but
theirs. :)


"bz" wrote:

My customers that still use Excel 2003 are complaining that my excel 2007
files (saved as .xls) don't print correctly - one problem is the last
column
on the right falls off the page (creates a new page). I increased my left
and

right margins and made sure the form fit on the page but when they get it,
it

still doesn't fit on the page. This only started happening when I loaded
the
2007 software.
I thought if I saved it as a 2003 file, it would continut to look the same

to a 2003 Excel user.
Anyone know what to do about this problem?
Tried to reinstall 2003 but get a "can't find a source" message.

2007 file saved as .xls prints wrong on computer w 2003 softwa
 

In article , ?B?Yno=?= wrote:
The customer receives the same excel reports from me every month and the
problem started when I installed 2007. Neither of us changed printers but
that was the first thing I asked.
In the meantime I sent the file to a local computer that still has 2003 so I
could see what customer is seeing - figured out what is going on. I always
use €œautofit columns€� formatted as accounting $ so of course I did the same

thing using the 2007 version. But when I opened the file using the 2003
Excel, it lost that formatting and the columns were wider than they should
have been. So thats why my customer was complaining that the last column
didnt fit on the page.
Of course, I have no clue why it loses the formatting (autofit) but at least
I know whats happening to her. Thank you.

Sorry my suggestion wasn't useful ... but good news that the problem is
fixed. :)


"Bruce Sinclair" wrote:

In article ,
?B?U2hhbmUgRGV2ZW5zaGlyZQ==?=
wrote:
Are they using the Fit to Page option in Page Setup?

They'll have a different printer, right ? Get them to set their
spreadsheet up how they want it to print. All printers are different (eg
printable areas) ... and I suspect this is not actually your problem, but
theirs. :)


"bz" wrote:

My customers that still use Excel 2003 are complaining that my excel 2007
files (saved as .xls) don't print correctly - one problem is the last
column
on the right falls off the page (creates a new page). I increased my left
and

right margins and made sure the form fit on the page but when they get it,
it

still doesn't fit on the page. This only started happening when I loaded
the
2007 software.
I thought if I saved it as a 2003 file, it would continut to look the same

to a 2003 Excel user.
Anyone know what to do about this problem?
Tried to reinstall 2003 but get a "can't find a source" message.

2007 file saved as .xls prints wrong on computer w 2003 softwa
 

Hi,

If you can use macros , here's a workaround:
- Open your workbook
- Press Alt+F11
- Double-click ThisWorkbook object and
- Insert something like:

Private Sub Workbook_Open()
Range("A1:A10").NumberFormat = "$#,##0.00"
End Sub



On Nov 17, 1:35*am, bz wrote:
Thanks but you were right - the printer is normally the problem.
Actually my problem isn't fixed, I just know what's happening now and have
to do her work using 2003. *I have to figure out why I can't reinstall 2003
on this computer. *I'm having to do her work on an old computer. *I may have
to post a new question on that if I can't get it to work.



"Bruce Sinclair" wrote:
In article , ?B?Yno=?= wrote:
The customer receives the same excel reports from me every month and the
problem started when I installed 2007. *Neither of us changed printers but
that was the first thing I asked.
In the meantime I sent the file to a local computer that still has 2003 so I
could see what customer is seeing - figured out what is going on. *I always
use €œautofit columns€ *formatted as accounting $ so of course I did the same

thing using the 2007 version. *But when I opened the file using the 2003
Excel, it lost that formatting and the columns were wider than they should
have been. *So thats why my customer was complaining that the last column
didnt fit on the page.
Of course, I have no clue why it loses the formatting (autofit) but at least
I know whats happening to her. *Thank you.

Sorry my suggestion wasn't useful ... but good news that the problem is
fixed. :)

"Bruce Sinclair" wrote:

In article ,
?B?U2hhbmUgRGV2ZW5zaGlyZQ==?=
wrote:
Are they using the Fit to Page option in Page Setup?

They'll have a different printer, right ? Get them to set their
spreadsheet up how they want it to print. All printers are different (eg
printable areas) ... and I suspect this is not actually your problem, but
theirs. :)

"bz" wrote:

My customers that still use Excel 2003 are complaining that my excel 2007
files (saved as .xls) don't print correctly - one problem is the last
column
on the right falls off the page (creates a new page). I increased my left
and

right margins and made sure the form fit on the page but when they get it,
it

still doesn't fit on the page. This only started happening when I loaded
the
2007 software.
I thought if I saved it as a 2003 file, it would continut to look the same

to a 2003 Excel user.
Anyone know what to do about this problem?
Tried to reinstall 2003 but get a "can't find a source" message.- Hide quoted text -

- Show quoted text -