I have used your template file with code segment, the print preview of the output file is fine. I don't find any issue, I am using MS Excel 2007 (Office Professional Plus Edition 2007) on my pc.
"Note: The normalized file is working fine (can see print preview properly) in Microsoft Office Ultimate 2007.
The issue is only with setting up cells properties and viewing preview in Microsoft Office Professional Plus 2007."
Could you give us Ms Excel version details, also provide us screenshots of the print preview to show the issue with details. We will check it soon.