Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print defaults for e-mailed file | Excel Discussion (Misc queries) | |||
Is there a way to change my defaults to print the entire workbook? | Excel Discussion (Misc queries) | |||
print defaults at 20 copies | Excel Discussion (Misc queries) | |||
Printing: how do I amend my print defaults? | Excel Discussion (Misc queries) | |||
How do I change print option defaults? | Setting up and Configuration of Excel |