Excel 2007 printing does not scale properly

[John Ruff]

I can no longer adjust my documents to fit to a specified number of pages
wide
and tall without Excel changing my document to print across hundreds or even
thousands of pages. This occurs no matter if printing in Portrait or
Landscape.

 

[Otto Moehrbach]

John
Explain what you do to make Excel print. In detail and very specific.
Every step in the process. Specifically, I am looking for how you tell
Excel WHAT to print. HTH Otto

 

[John Ruff]

The following is performed:
1. Select Print Preview > Page Setup.
2. Portrait is selected
3. Fit to: is selected. , 1 wide by 2 tall or 1 wide by 3 tall would be
selected

When looking at the lower left of the page the number of pages would say
"Preview: Page 1 of 8985" or "Preview: Page 1 of 10731", etc. The total
number of pages would be random.

The user who is having this problem states it does not happen everytime she
works with Excel but it is random. No specific spreadsheet encounters this
issue, but any one of them she opens or creates may display this
issue.Today, the spreadsheets that were displaying the phenomenon, are
printing correctly.

Go figure :-(

 

[Otto Moehrbach]

John
You didn't say anything about how she tells Excel WHAT to print. If you
don't specifically tell Excel what to print, Excel will use some rules to
determine (guess???) what to print, depending on, among other things, the
location of the active cell. This can sometimes result in Excel printing
something you don't want. You and your users should get into the habit of
always specifying the range you want printed. That way, Excel is not
guessing what you want. There are several ways of specifying the print
range. Look it up in Help. Otto

 

[AdamV]

I tend to see users have problems with too much stuff printing when they
have selected huge areas or even whole rows / columns and added
(horrible) borders.
However, this sounds slightly different to how John describes this
problem. No matter how much you select or where it is, if you choose to
fit to x by y pages, you should see page 1 of (x*y) not some randomly
large number.

Best guess would be a printer driver issue since it will be calculating
how to fit onto a page of the size set in the print properties. Try
setting a different default printer before starting Ezcel and see if you
can keep the problem from recurring that way (and if that works then try
getting an updated driver for example).

Hope this helps
Adam Vero
MCAS:I

 

[John Ruff]

Thanks Adam,

The user and I have been using Excel for many years and we've never had
issues like this in printing. A one, two, three, or four page document
should not be wanting to print thousands of pages. Your suggestion about the
printer drivers sound like a good solution. We'll update her printer drivers
and see if this solves this random issue.

papparuff