EXCEL 2019 and Print Layout Issues

Hi Guys,

I have a new work laptop; which is running excel 2019. The issue I have all the docs that were created using MS Excel 2010 are not printing correctly in 2019.

For Example:
The Scaling settings are set for "Fit columns on one page" in 2010 the print preview is perfect (the row alignment is what I want); however when i open the same doc in 2019 the print preview shows some rows that should be on page one on page 2 etc. The amount of rows per page break are different when 2010 and 2019 are compared.

I have checked all settings in the page setup and as far as I can see everything is identical - which should be the case.



Can anyone shed a light on what is the issue here? Any thoughts would be greatly appreciated.

Kind Regards,
Derek