I am having a problem with the formatting once a workbook is saved as a pdf file. when i view the individual sheets within the workbook in print preview, they look fine (fit to one page), but as soon as I print or save to pdf, the individual sheets lose all formatting (everything seems to expand - spaces are larger, fewer words on the sheet, logo is twice the size). I have even tried using the save as xps file. I have both typed code and also recorded a macro to see if it made any difference.

Any suggestions?

HELP!!