I'm working with a workbook that when I grouped all of the pages and printed
the entire workbook printed on 17 pages. When I ungrouped the workbook with
the page break preview on, one worksheet that was only 2 pages on the initial
print (which was somewhere around 70% scaled) is now 44 pages! The worksheet
is only 6 pages when I set the scale to 100%. When I go to reduce the
scaling, it will not fit to 1 page wide any longer (says to do so would
violate the Excel rule limiting scaling to values below 10%). I've gone to
the page break preview and attempt to drag the right limit of the page over,
it scales the worksheet to print on 44 pages (supposedly at 10%)!

I'd really like to get my workbook back to printing on 1 page wide (legal).