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

[bz]

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.

 

[Shane Devenshire]

Hi,

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

Cheers,
Shane Devenshire

 

[bz]

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.

 

[Bruce Sinclair]

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]

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

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]

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.

 

[2007FanFoe]

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