Screen and print formatting migrated files
 

I hope I am permitted to re-post but original was in completely the
wrong place and I do not know how to move it.

I cannot print a colleague's excel files properly.

I received an excel file from a colleague's pc but the page formatting
is completely changed when opened on my pc. Even if I ensure page setup
is exactly the same, specify the same printer and make no changes to
font etc. text which will appear OK on colleague's pc under print
preview and when printed will over-run onto second page when opened in
my excel.

No problems within cells etc - just the overall page size.

Same if I try to convert to PDF.

Colleague has set up this 100 page (100 worksheets) set of financial
reports by typing text into first cell at left and letting it run over
onto the rest of cells in row. On her pc the text looks fine but on
mine the page breaks cut it off.

Apart from being long, the report has multiply columns and so the data
cannot be simply re-formatted. I know all about fitting to one page etc
but this makes text too small in some cases and in any case should not
be necessary.

Only difference is that we use different versions of excel but I feel
this should not be an issue in this case.


--
banus
------------------------------------------------------------------------
banus's Profile: http://www.excelforum.com/member.php...o&userid=27407
View this thread: http://www.excelforum.com/showthread...hreadid=470194