I've been having the same problem. If you activate multiple sheets, then
tell it to print multiple pages per sheet, Excel only prints the first page
in the multiple sheet format (i.e., one small page in the upper left of the
page.) The rest of the pages come out full size on separate sheets.

Does anyone know how to remedy this. It's been driving me crazy