I've found a flaw in excel 2007. when I filter a column in excel; I can then
set the print area and launch a print preview to see the selected area of
data. If I choose to send & email as a pdf instead; the same print area
suddenly turns into many pages because the capture ignores my filtered area.
Technically speaking; both outputs shoud get you the same data.