Recently lost the ability to set traditional print parameters within the
Excel 'Print Preview' panel. The "Settings..." button is still there (NOT
greyed-out), but does nothing!?!?!?
Could it be related to having upgraded my printer (now EpsonR300; was
LexMark).
Any suggestions would be appreciated
--
mac

Some of the print settings are not available when in Print Preview.

1. Print Titles is not available.

2. Print Area is not available.

3. Print Comments is not available.

These must be accessed through FilePage Setup.


Gord Dibben Excel MVP

On Tue, 5 Apr 2005 14:55:02 -0700, "mac@bath"
wrote:

Recently lost the ability to set traditional print parameters within the
Excel 'Print Preview' panel. The "Settings..." button is still there (NOT
greyed-out), but does nothing!?!?!?
Could it be related to having upgraded my printer (now EpsonR300; was
LexMark).
Any suggestions would be appreciated

Gord
Many thanks for very prompt response.
Understand your comments, but the "Setup.." button actually animates (as if
depressed) but NO action. Margins works. Zoom works. Print works.
Normal/layout views works.
I was expecting to see the tabs for (eg) Portrait/Landscape; 1:1 or %-ge
number of pages; header/footer; etc. etc.
I'm SURE it was there before!?!?
Still hoping I can get it back...it was SOOO helpful in visualisng the "fit"
of particular data to a sensible pagination/layout, where presentation/visual
continuity are important.

Am I wrong to be suspicious of having changed my printer?

If the worst happens I COULD re-instal, but then I get very nervous of
retaining the helpful addins & small personal/button Macros that I have
installed. would I loose them??
Thanks for continued patience

Or am I confused (comes with age!!) that my works/office version of Excel
(XP2003) allows this function, but not the 2000 version I have at home??.

"Gord Dibben" wrote:

Some of the print settings are not available when in Print Preview.

1. Print Titles is not available.

2. Print Area is not available.

3. Print Comments is not available.

These must be accessed through FilePage Setup.

Recently lost the ability to set traditional print parameters within the
Excel 'Print Preview' panel. The "Settings..." button is still there (NOT
greyed-out), but does nothing!?!?!?
Could it be related to having upgraded my printer (now EpsonR300; was
LexMark).