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.