#1   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default print defaults

My version of Excel 2003 has a print default of "Print entire workbook". I
tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it didn't
work.
Don Fritz
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 533
Default print defaults

I don't think I've ever seen Excel default to anything other than Selected
Sheet(s). Very strange. Does it happen in safe mode?

--
Jim
"Don" wrote in message
...
| My version of Excel 2003 has a print default of "Print entire workbook".
I
| tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it didn't
| work.
| Don Fritz


  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default print defaults

In Safe mode, there are no printers available to test. I've started new
workbooks, and old spreedsheets, and all default to print all.
--
Don Fritz


"Jim Rech" wrote:

I don't think I've ever seen Excel default to anything other than Selected
Sheet(s). Very strange. Does it happen in safe mode?

--
Jim
"Don" wrote in message
...
| My version of Excel 2003 has a print default of "Print entire workbook".
I
| tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it didn't
| work.
| Don Fritz



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 788
Default print defaults

Hi Don,

My excel 2003 install does the same thing. It prints the entire workbook
when I just use the print shortcut button. Though when I choose FilePrint
the default is set to Current Sheet and only prints the current sheet. I
haven't been able to find out to this date how to fix this issue. If you have
resolved this, could you let me know?

Cheers,

Chris.

"Don" wrote:

In Safe mode, there are no printers available to test. I've started new
workbooks, and old spreedsheets, and all default to print all.
--
Don Fritz


"Jim Rech" wrote:

I don't think I've ever seen Excel default to anything other than Selected
Sheet(s). Very strange. Does it happen in safe mode?

--
Jim
"Don" wrote in message
...
| My version of Excel 2003 has a print default of "Print entire workbook".
I
| tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it didn't
| work.
| Don Fritz



  #5   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default print defaults

Mine defaults to entire workbook both with the printshortcut and the file
print. I am hoping for a quick fix, but if that fails, I will have to try a
re-install. I read a while back that someone wanted to change the default to
entire workbook, but was told that it wasn't possible??????????????
--
Don Fritz


"Chris" wrote:

Hi Don,

My excel 2003 install does the same thing. It prints the entire workbook
when I just use the print shortcut button. Though when I choose FilePrint
the default is set to Current Sheet and only prints the current sheet. I
haven't been able to find out to this date how to fix this issue. If you have
resolved this, could you let me know?

Cheers,

Chris.

"Don" wrote:

In Safe mode, there are no printers available to test. I've started new
workbooks, and old spreedsheets, and all default to print all.
--
Don Fritz


"Jim Rech" wrote:

I don't think I've ever seen Excel default to anything other than Selected
Sheet(s). Very strange. Does it happen in safe mode?

--
Jim
"Don" wrote in message
...
| My version of Excel 2003 has a print default of "Print entire workbook".
I
| tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it didn't
| work.
| Don Fritz





  #6   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default print defaults

Read all replies to my post, and you will probably discover that an add-in is
causing your problem. So the answer for those that want to print all sheets
may to add an add-in?
--
Don Fritz


"Chris" wrote:

Hi Don,

My excel 2003 install does the same thing. It prints the entire workbook
when I just use the print shortcut button. Though when I choose FilePrint
the default is set to Current Sheet and only prints the current sheet. I
haven't been able to find out to this date how to fix this issue. If you have
resolved this, could you let me know?

Cheers,

Chris.

"Don" wrote:

In Safe mode, there are no printers available to test. I've started new
workbooks, and old spreedsheets, and all default to print all.
--
Don Fritz


"Jim Rech" wrote:

I don't think I've ever seen Excel default to anything other than Selected
Sheet(s). Very strange. Does it happen in safe mode?

--
Jim
"Don" wrote in message
...
| My version of Excel 2003 has a print default of "Print entire workbook".
I
| tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it didn't
| work.
| Don Fritz



  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default print defaults

jim! Thanks m8!

I was searching for a while before I came across this post. You were
exactly right in my case. i removed the add-on and after that it was
defaulting to active worksheets again.


Best regards,
Brent
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 533
Default print defaults

Strange. I have all my printers available in safe mode.

--
Jim
"Don" wrote in message
...
| In Safe mode, there are no printers available to test. I've started new
| workbooks, and old spreedsheets, and all default to print all.
| --
| Don Fritz
|
|
| "Jim Rech" wrote:
|
| I don't think I've ever seen Excel default to anything other than
Selected
| Sheet(s). Very strange. Does it happen in safe mode?
|
| --
| Jim
| "Don" wrote in message
| ...
| | My version of Excel 2003 has a print default of "Print entire
workbook".
| I
| | tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it
didn't
| | work.
| | Don Fritz
|
|
|


  #9   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default print defaults

It has been awhile since I had to go to safe mode. My PC is networked and
the only Safe mode that works is with network options. In safe mode
selecting file-print gives you the message "no printer selected". Going to
add printer, you get the message "print spooler not available in safe mode".
--
Don Fritz


"Jim Rech" wrote:

Strange. I have all my printers available in safe mode.

--
Jim
"Don" wrote in message
...
| In Safe mode, there are no printers available to test. I've started new
| workbooks, and old spreedsheets, and all default to print all.
| --
| Don Fritz
|
|
| "Jim Rech" wrote:
|
| I don't think I've ever seen Excel default to anything other than
Selected
| Sheet(s). Very strange. Does it happen in safe mode?
|
| --
| Jim
| "Don" wrote in message
| ...
| | My version of Excel 2003 has a print default of "Print entire
workbook".
| I
| | tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it
didn't
| | work.
| | Don Fritz
|
|
|



  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 533
Default print defaults

I'm sorry I meant "Excel safe mode".

From Start-Run enter "Excel.exe /s" (no quotes, there is a space before the
slash)

--
Jim
"Don" wrote in message
...
| It has been awhile since I had to go to safe mode. My PC is networked and
| the only Safe mode that works is with network options. In safe mode
| selecting file-print gives you the message "no printer selected". Going to
| add printer, you get the message "print spooler not available in safe
mode".
| --
| Don Fritz
|
|
| "Jim Rech" wrote:
|
| Strange. I have all my printers available in safe mode.
|
| --
| Jim
| "Don" wrote in message
| ...
| | In Safe mode, there are no printers available to test. I've started
new
| | workbooks, and old spreedsheets, and all default to print all.
| | --
| | Don Fritz
| |
| |
| | "Jim Rech" wrote:
| |
| | I don't think I've ever seen Excel default to anything other than
| Selected
| | Sheet(s). Very strange. Does it happen in safe mode?
| |
| | --
| | Jim
| | "Don" wrote in message
| | ...
| | | My version of Excel 2003 has a print default of "Print entire
| workbook".
| | I
| | | tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it
| didn't
| | | work.
| | | Don Fritz
| |
| |
| |
|
|
|




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print defaults for e-mailed file Tasha Excel Discussion (Misc queries) 0 December 19th 07 07:36 PM
Is there a way to change my defaults to print the entire workbook? Ronimad Excel Discussion (Misc queries) 2 July 31st 07 08:24 PM
print defaults at 20 copies KneeDown2Up Excel Discussion (Misc queries) 2 July 13th 07 05:50 PM
Printing: how do I amend my print defaults? joo Excel Discussion (Misc queries) 7 September 21st 06 02:00 PM
How do I change print option defaults? Glen Setting up and Configuration of Excel 3 January 26th 06 12:26 PM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"