Number of pages in worksheet doesn't match Print Preview pages

**delru** · May 10th, 2010, 09:12 PM posted to microsoft.public.excel.misc

I have a 16-page worksheet. When I try to print or go into print preview, it
shows the document is 160 pages. Upon review, it looks like it's just
printing 10 copies of the 16 page worksheet, but ONLY 1 COPY is chosen. This
doesn't happen with any other file/worksheet, and can't find why on this one.

**Trekman** · May 10th, 2010, 10:08 PM posted to microsoft.public.excel.misc

On May 10, 4:12*pm, delru wrote:
I have a 16-page worksheet. *When I try to print or go into print preview, it
shows the document is 160 pages. *Upon review, it looks like it's just
printing 10 copies of the 16 page worksheet, but ONLY 1 COPY is chosen. *This
doesn't happen with any other file/worksheet, and can't find why on this one.

Is each worksheet only 1 page of printing? Try printing only 1 of
your worksheets and see if the selected print range gives you multiple
printed pages. This is what I would suspect rather that the app just
deciding to do multi copies.

**Dave Peterson[_2_]** · May 10th, 2010, 10:10 PM posted to microsoft.public.excel.misc

I'd look at the print range (on each of the 16 sheets). Make sure it's what
it's supposed to be.

If it looks ok, I'd look to see if I added page breaks by mistake.

ps. Do you mean that you have a 16 sheet workbook?

delru wrote:
I have a 16-page worksheet. When I try to print or go into print preview, it
shows the document is 160 pages. Upon review, it looks like it's just
printing 10 copies of the 16 page worksheet, but ONLY 1 COPY is chosen. This
doesn't happen with any other file/worksheet, and can't find why on this one.

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode