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. 

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" <papparuff@comcast.net> wrote in message 
news:#eYnG4OeKHA.4880@TK2MSFTNGP05.phx.gbl...
> 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.
> 

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" <moehrbachoextra@bellsouth.net> wrote in message 
news:O5DhqSPeKHA.2164@TK2MSFTNGP02.phx.gbl...
> 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" <papparuff@comcast.net> wrote in message 
> news:#eYnG4OeKHA.4880@TK2MSFTNGP05.phx.gbl...
>> 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.
>> 

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
"John Ruff" <papparuff@comcast.net> wrote in message 
news:uU9W6vPeKHA.1156@TK2MSFTNGP05.phx.gbl...
> 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" <moehrbachoextra@bellsouth.net> wrote in message 
> news:O5DhqSPeKHA.2164@TK2MSFTNGP02.phx.gbl...
>> 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" <papparuff@comcast.net> wrote in message 
>> news:#eYnG4OeKHA.4880@TK2MSFTNGP05.phx.gbl...
>>> 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.
>>>
>
> 

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

Otto Moehrbach wrote:
> 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
> "John Ruff" <papparuff@comcast.net> wrote in message 
> news:uU9W6vPeKHA.1156@TK2MSFTNGP05.phx.gbl...
>> 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" <moehrbachoextra@bellsouth.net> wrote in message 
>> news:O5DhqSPeKHA.2164@TK2MSFTNGP02.phx.gbl...
>>> 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" <papparuff@comcast.net> wrote in message 
>>> news:#eYnG4OeKHA.4880@TK2MSFTNGP05.phx.gbl...
>>>> 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.
>>>>
>>
>>

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

"AdamV" <nospam@meteorit.co.uk> wrote in message 
news:eMbUWxSeKHA.1824@TK2MSFTNGP04.phx.gbl...
>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
>
> Otto Moehrbach wrote:
>> 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
>> "John Ruff" <papparuff@comcast.net> wrote in message 
>> news:uU9W6vPeKHA.1156@TK2MSFTNGP05.phx.gbl...
>>> 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" <moehrbachoextra@bellsouth.net> wrote in message 
>>> news:O5DhqSPeKHA.2164@TK2MSFTNGP02.phx.gbl...
>>>> 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" <papparuff@comcast.net> wrote in message 
>>>> news:#eYnG4OeKHA.4880@TK2MSFTNGP05.phx.gbl...
>>>>> 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.
>>>>>
>>>
>>>