Mchael is correct. Use PNG when possible. It seems to be the Format that allows for smaller sizes PNG is not a Lossy format. supposedly jpeg2000 (I think its listed as jpe in some graphic apps) is not lossy but despite many years being out, it's not widely used. .tiff is ideal but it’s largest file size of any I am aware of. I'm not familiar enough with the PC only types to comment on how they would do.
Thanks for the quick responses. Switching to a PNG format logo did make a noticeable difference, but I still have to resort to a custom print setting (better than High Quality or Press Quality) and turning off or reducing compression (which bloats the file size) to keep it looking as good as I want. I think I can find a happy medium with my custom settings, but the spreadsheet won't be user-friendly if each user needs to have the custom print settings configured and remember to use them.
My project to programmatically adjust the Acrobat print settings in VBA has just been pushed to the front-burner, I suppose!
This tip "may" apply only if your using a Mac, or may be the same feature in Windows as well:
when you open the Print menu:
- Set up your printer as you have.
- Second button from top is called Presets
- Click on Presets and scroll all the way down to save preset
- when window opens, in the Field give a Name.