Since upgrading to 2007, I wonder is there anyway to change the "print what"
default in Excel 2007. Currently the default is set to print the whole
workbook...I never print the workbook always the worksheet. I know you can
click the current worksheet button...but in 2003 I didn't have to do
that...this is driving me crazy. Is there a way to change it so the default
is set to current worksheet. Any help would be greatly appreciated.
Thanks
Richard - 13 Mar 2008 17:01 GMT
I am having the same problem except that it's with Excel 2003. Somewhere
along the line my default setting for the 'print what' options in the print
dialogue has been changed from printing just the active worksheet to printing
the entire workbook which is causing me no end of grief.
Even when selecting 'active worksheet' and previewing, once the preview
window is closed the 'print what' setting has changed itself back to print
entire workbook, which is frequently causing hundreds of spurious pages to be
sent to my printer. I cannot find any default setting options to change it
back. This is most frustrating.
To make matters worse I've got a feeling that as I send excel workbooks to
clients on a regular basis, some have reported experiencing the same problems
with their own workbooks that have had nothing to do with mine, but with the
problem manifesting itself only since I've uploaded or emailed workbooks to
their system that I've modified and saved on my own system suggesting that
the problem is spreading....
> Since upgrading to 2007, I wonder is there anyway to change the "print what"
> default in Excel 2007. Currently the default is set to print the whole
[quoted text clipped - 4 lines]
>
> Thanks
Z - 15 Apr 2008 00:05 GMT
I'm having the same annoying problem, anyone have a fix?
> Since upgrading to 2007, I wonder is there anyway to change the "print what"
> default in Excel 2007. Currently the default is set to print the whole
[quoted text clipped - 4 lines]
>
> Thanks
Robin - 07 May 2008 20:08 GMT
Nope not yet....
:(
> I'm having the same annoying problem, anyone have a fix?
>
[quoted text clipped - 6 lines]
> >
> > Thanks