Quattro Pro: Page Count over 1000 message warning when printing.

0 users found this article helpful

Symptoms:

When printing a sheet, a message is seen stating, "Page count over 1000. The print block is too large. Use a smaller print block."

Warning Icon. Page count over 1000. The Print block is too large. Use a smaller print block.

Cause:

A cell in the lower or right corner of the sheet has been used / has data in it 

Resolutions:

1) Select the desired print area.

  1. Open the spreadsheet
  2. Select the area you wish to print
  3. Click File > Print.
  4. Note that "Selection" is enabled in the print dialog. Leave this enabled.
  5. Select any other desired print options
  6. Click Print

2) Clean up the spreadsheet:

  1. Open the spreadsheet
  2. Click File > Save As, and save it to a new filename to create a backup 
  3. Hold shift. While holding shift, tap End, then tap Home, the screen will turn black as a large number of cells are selected
  4. Right click on the black cells and choose "Delete Cells..."
  5. If you see a speed warning like this, click Yes:
  6. Wait for the mouse cursor to turn back from an hourglass / wait cursor.
  7. Press Home on your keyboard (or use the scroll bars) to go to the top of the sheet.
  8. Save the sheet to the new filename
  9. Try Printing.

Was this article helpful?

Tell us how we can improve it.