Microsoft KB Archive/63775

Multiplan: Page Numbers Incorrect for Multiple Copies PSS ID Number: Q63775 Article last modified on 08-28-1990 PSS database name: D_MPlan

4.20

MS-DOS

Summary:

Multiplan version 4.20 allows more than one copy of a worksheet to be printed automatically using the Print Options “# of copies:” field. If page numbers are specified in a header or footer, the page numbers increment each time a page is printed. However, page numbers specified in the header or footer do not restart at Page 1 for each of the copies printed.

One way to work around this problem is to write a macro that will print the worksheet multiple times, instead of utilizing the Print Options “# of copies:” field.

More Information:

To duplicate this problem, follow these steps:


 * 1) Load a two-page worksheet.
 * 2) Choose Alpha and enter the header “Page &P” in an empty cell.
 * 3) Choose Print Heading and enter the cell location containing the header in the “header:” field. Press the ENTER key.
 * 4) Specify a print area in the Print Options “area:” field. Change the “# of copies:” field to 3. Press the ENTER key.
 * 5) Choose Print Printer. Observe that the pages are numbered 1, 2, 3, 4, 5, 6. The page numbers should restart for each of the three copies, providing the following sequence of page numbers: 1, 2, 1, 2, 1, 2.

When page numbers are being printed on multiple copies, it is recommended that the worksheet is printed one copy at a time. A macro can be written for this purpose.

Copyright Microsoft Corporation 1990.