ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   'Windows in Taskbar' Excel2003 vs 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/212069-windows-taskbar-excel2003-vs-2007-a.html)

John[_24_]

'Windows in Taskbar' Excel2003 vs 2007
 
I am running Excel2003 routinely; I am set up with 'Windows in
Taskbar' unchecked so that as I click on multiple *.xls files (say in
Windows Explorer) only one instance of the application is open and all
spreadsheets are visible in the Window pull down menu. I recently
installed Excel2007 and only want to run this on specific files, so I
changed the file associations so that 2003 opens xls files....
My problem is that now whenever I click on an xls file, a new instance
of Excel is launched; what I want is for a single instance to list all
open spreadsheets. The puzzling part is that the 'Windows in taskbar
box is still unchecked! I also opened my Personal xls and made sure
the box was unchecked there as well. It's almost as if there is a
default set by 2007 somewhere and is not controlled by the Tools/
Options/View dialog. I'm not real comfortable in the Registry,
although I did find a post by Gord Dibben (I think, apologies if I
misquoted) detailing Registering and deregistering versions that I
might try if all else fails.

Thanks much for any insight. John

John[_24_]

'Windows in Taskbar' Excel2003 vs 2007
 
On Dec 1, 11:28*am, John wrote:
I am running Excel2003 routinely; I am set up with 'Windows in
Taskbar' unchecked so that as I click on multiple *.xls files (say in
Windows Explorer) only one instance of the application is open and all
spreadsheets are visible in the Window pull down menu. I recently
installed Excel2007 and only want to run this on specific files, so I
changed the file associations so that 2003 opens xls files....
My problem is that now whenever I click on an xls file, a new instance
of Excel is launched; what I want is for a single instance to list all
open spreadsheets. The puzzling part is that the 'Windows in taskbar
box is still unchecked! I also opened my Personal xls and made sure
the box was unchecked there as well. It's almost as if there is a
default set by 2007 somewhere and is not controlled by the Tools/
Options/View dialog. I'm not real comfortable in the Registry,
although I did find a post by Gord Dibben (I think, apologies if I
misquoted) detailing Registering and deregistering versions that I
might try if all else fails.

Thanks much for any insight. * John


I have tried de-registering and re-registering as suggested by Dave
Peterson in a response to a similar post (Sorry I mis-cited you
earlier) with no luck. I have also tried enabling 'Windows in taskbar,
followed by disabling the function, again with no luck. Seems like the
checkbox has no effect now. Looking for any other possible routes...

Chip Pearson

'Windows in Taskbar' Excel2003 vs 2007
 

Try changing the "Ignore Other Applications" setting in the Options
dialog (on the Tools menu).

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 1 Dec 2008 09:42:01 -0800 (PST), John
wrote:

On Dec 1, 11:28*am, John wrote:
I am running Excel2003 routinely; I am set up with 'Windows in
Taskbar' unchecked so that as I click on multiple *.xls files (say in
Windows Explorer) only one instance of the application is open and all
spreadsheets are visible in the Window pull down menu. I recently
installed Excel2007 and only want to run this on specific files, so I
changed the file associations so that 2003 opens xls files....
My problem is that now whenever I click on an xls file, a new instance
of Excel is launched; what I want is for a single instance to list all
open spreadsheets. The puzzling part is that the 'Windows in taskbar
box is still unchecked! I also opened my Personal xls and made sure
the box was unchecked there as well. It's almost as if there is a
default set by 2007 somewhere and is not controlled by the Tools/
Options/View dialog. I'm not real comfortable in the Registry,
although I did find a post by Gord Dibben (I think, apologies if I
misquoted) detailing Registering and deregistering versions that I
might try if all else fails.

Thanks much for any insight. * John


I have tried de-registering and re-registering as suggested by Dave
Peterson in a response to a similar post (Sorry I mis-cited you
earlier) with no luck. I have also tried enabling 'Windows in taskbar,
followed by disabling the function, again with no luck. Seems like the
checkbox has no effect now. Looking for any other possible routes...


Jim Rech

'Windows in Taskbar' Excel2003 vs 2007
 
Windows in Taskbar has no effect on whether Excel opens each workbook in
separate Excel instances. Re-registering Excel 2003 is the best answer to
opening XLS files in one instance of Excel 2003. You said you re-registered
but, if it didn't work, you might have done it to Excel 2007.

First get the full path to Excel 2003 from Windows Explorer. Below is the
usual path:

Then from Start-Run enter: C:\Program Files\Microsoft
Office\Office11\Excel.exe /regserver

There is a space after Excel.exe and before the slash.


--
Jim
"John" wrote in message
...
On Dec 1, 11:28 am, John wrote:
I am running Excel2003 routinely; I am set up with 'Windows in
Taskbar' unchecked so that as I click on multiple *.xls files (say in
Windows Explorer) only one instance of the application is open and all
spreadsheets are visible in the Window pull down menu. I recently
installed Excel2007 and only want to run this on specific files, so I
changed the file associations so that 2003 opens xls files....
My problem is that now whenever I click on an xls file, a new instance
of Excel is launched; what I want is for a single instance to list all
open spreadsheets. The puzzling part is that the 'Windows in taskbar
box is still unchecked! I also opened my Personal xls and made sure
the box was unchecked there as well. It's almost as if there is a
default set by 2007 somewhere and is not controlled by the Tools/
Options/View dialog. I'm not real comfortable in the Registry,
although I did find a post by Gord Dibben (I think, apologies if I
misquoted) detailing Registering and deregistering versions that I
might try if all else fails.

Thanks much for any insight. John


I have tried de-registering and re-registering as suggested by Dave
Peterson in a response to a similar post (Sorry I mis-cited you
earlier) with no luck. I have also tried enabling 'Windows in taskbar,
followed by disabling the function, again with no luck. Seems like the
checkbox has no effect now. Looking for any other possible routes...


Jim Cone[_2_]

'Windows in Taskbar' Excel2003 vs 2007
 
It also helps if the two Excel versions are installed in separate folders.
--
Jim Cone
Portland, Oregon USA


"John"
wrote in message
I have tried de-registering and re-registering as suggested by Dave
Peterson in a response to a similar post (Sorry I mis-cited you
earlier) with no luck. I have also tried enabling 'Windows in taskbar,
followed by disabling the function, again with no luck. Seems like the
checkbox has no effect now. Looking for any other possible routes...

John[_24_]

'Windows in Taskbar' Excel2003 vs 2007
 
On Dec 1, 12:42*pm, John wrote:
On Dec 1, 11:28*am, John wrote:



I am running Excel2003 routinely; I am set up with 'Windows in
Taskbar' unchecked so that as I click on multiple *.xls files (say in
Windows Explorer) only one instance of the application is open and all
spreadsheets are visible in the Window pull down menu. I recently
installed Excel2007 and only want to run this on specific files, so I
changed the file associations so that 2003 opens xls files....
My problem is that now whenever I click on an xls file, a new instance
of Excel is launched; what I want is for a single instance to list all
open spreadsheets. The puzzling part is that the 'Windows in taskbar
box is still unchecked! I also opened my Personal xls and made sure
the box was unchecked there as well. It's almost as if there is a
default set by 2007 somewhere and is not controlled by the Tools/
Options/View dialog. I'm not real comfortable in the Registry,
although I did find a post by Gord Dibben (I think, apologies if I
misquoted) detailing Registering and deregistering versions that I
might try if all else fails.


Thanks much for any insight. * John


I have tried de-registering and re-registering as suggested by Dave
Peterson in a response to a similar post (Sorry I mis-cited you
earlier) with no luck. I have also tried enabling 'Windows in taskbar,
followed by disabling the function, again with no luck. Seems like the
checkbox has no effect now. Looking for any other possible routes...


Thank you all for your suggestions, alas, no luck unfortunately. I
have "Ignore other apps" checked, re-registered (insuring I was
pointing at 2003 exe) and have the 2 versions loaded in different
directories. No joy. I'll keep looking and report back if I ever solve
this.

Attn Jim Rech, Your comment that the Windows in Taskbar option has
no effect puzzles me. What does it control in that case?

Thanks again all

John

Jim Rech

'Windows in Taskbar' Excel2003 vs 2007
 
What does it control in that case?

It controls whether each open window in Excel appears in the Windows
Taskbar, versus just "Excel" appearing there once.

If you start Excel from the Start menu and then do a File Open on three
workbooks, those three workbook will all in open in one instance of Excel.
If you select Windows in Taskbar, then they will appear there while still
being in the one Excel instance. It's just an easy way of navigating among
windows at the price of more Taskbar clutter.

--
Jim
"John" wrote in message
...
On Dec 1, 12:42 pm, John wrote:
On Dec 1, 11:28 am, John wrote:



I am running Excel2003 routinely; I am set up with 'Windows in
Taskbar' unchecked so that as I click on multiple *.xls files (say in
Windows Explorer) only one instance of the application is open and all
spreadsheets are visible in the Window pull down menu. I recently
installed Excel2007 and only want to run this on specific files, so I
changed the file associations so that 2003 opens xls files....
My problem is that now whenever I click on an xls file, a new instance
of Excel is launched; what I want is for a single instance to list all
open spreadsheets. The puzzling part is that the 'Windows in taskbar
box is still unchecked! I also opened my Personal xls and made sure
the box was unchecked there as well. It's almost as if there is a
default set by 2007 somewhere and is not controlled by the Tools/
Options/View dialog. I'm not real comfortable in the Registry,
although I did find a post by Gord Dibben (I think, apologies if I
misquoted) detailing Registering and deregistering versions that I
might try if all else fails.


Thanks much for any insight. John


I have tried de-registering and re-registering as suggested by Dave
Peterson in a response to a similar post (Sorry I mis-cited you
earlier) with no luck. I have also tried enabling 'Windows in taskbar,
followed by disabling the function, again with no luck. Seems like the
checkbox has no effect now. Looking for any other possible routes...


Thank you all for your suggestions, alas, no luck unfortunately. I
have "Ignore other apps" checked, re-registered (insuring I was
pointing at 2003 exe) and have the 2 versions loaded in different
directories. No joy. I'll keep looking and report back if I ever solve
this.

Attn Jim Rech, Your comment that the Windows in Taskbar option has
no effect puzzles me. What does it control in that case?

Thanks again all

John


John[_24_]

'Windows in Taskbar' Excel2003 vs 2007
 
On Dec 1, 3:31*pm, "Jim Rech" wrote:
What does it control in that case?


It controls whether each open window in Excel appears in the Windows
Taskbar, versus just "Excel" appearing there once.

If you start Excel from the Start menu and then do a File Open on three
workbooks, those three workbook will all in open in one instance of Excel..
If you select Windows in Taskbar, then they will appear there while still
being in the one Excel instance. It's just an easy way of navigating among
windows at the price of more Taskbar clutter.

--
Jim"John" wrote in message

...
On Dec 1, 12:42 pm, John wrote:



On Dec 1, 11:28 am, John wrote:


I am running Excel2003 routinely; I am set up with 'Windows in
Taskbar' unchecked so that as I click on multiple *.xls files (say in
Windows Explorer) only one instance of the application is open and all
spreadsheets are visible in the Window pull down menu. I recently
installed Excel2007 and only want to run this on specific files, so I
changed the file associations so that 2003 opens xls files....
My problem is that now whenever I click on an xls file, a new instance
of Excel is launched; what I want is for a single instance to list all
open spreadsheets. The puzzling part is that the 'Windows in taskbar
box is still unchecked! I also opened my Personal xls and made sure
the box was unchecked there as well. It's almost as if there is a
default set by 2007 somewhere and is not controlled by the Tools/
Options/View dialog. I'm not real comfortable in the Registry,
although I did find a post by Gord Dibben (I think, apologies if I
misquoted) detailing Registering and deregistering versions that I
might try if all else fails.


Thanks much for any insight. John


I have tried de-registering and re-registering as suggested by Dave
Peterson in a response to a similar post (Sorry I mis-cited you
earlier) with no luck. I have also tried enabling 'Windows in taskbar,
followed by disabling the function, again with no luck. Seems like the
checkbox has no effect now. Looking for any other possible routes...


Thank you all for your suggestions, alas, no luck unfortunately. I
have "Ignore other apps" checked, re-registered (insuring I was
pointing at 2003 exe) and have the 2 versions loaded in different
directories. No joy. I'll keep looking and report back if I ever solve
this.

Attn Jim Rech, * Your comment that the Windows in Taskbar option has
no effect puzzles me. What does it control in that case?

Thanks again all

John


Problem Solved!!

Had to do with the file association, not exactly sure what as I
changed it to launch 2003 when opening any *xls file, but anyway, I re-
associated xls to a Excel Worksheet, and in the Advanced dialog box,
there is a checkbox for "Browse in a single window" (or similar).
Credit here at this link

http://www.tech-archive.net/pdf/Arch...6/msg00355.pdf

Thanks All

Jim Rech

'Windows in Taskbar' Excel2003 vs 2007
 
Had to do with the file association

Yes. That's what re-registering Excel would have fixed. Why it didn't for
you we'll never know.

--
Jim
"John" wrote in message
...
On Dec 1, 3:31 pm, "Jim Rech" wrote:
What does it control in that case?


It controls whether each open window in Excel appears in the Windows
Taskbar, versus just "Excel" appearing there once.

If you start Excel from the Start menu and then do a File Open on three
workbooks, those three workbook will all in open in one instance of Excel.
If you select Windows in Taskbar, then they will appear there while still
being in the one Excel instance. It's just an easy way of navigating among
windows at the price of more Taskbar clutter.

--
Jim"John" wrote in message

...
On Dec 1, 12:42 pm, John wrote:



On Dec 1, 11:28 am, John wrote:


I am running Excel2003 routinely; I am set up with 'Windows in
Taskbar' unchecked so that as I click on multiple *.xls files (say in
Windows Explorer) only one instance of the application is open and all
spreadsheets are visible in the Window pull down menu. I recently
installed Excel2007 and only want to run this on specific files, so I
changed the file associations so that 2003 opens xls files....
My problem is that now whenever I click on an xls file, a new instance
of Excel is launched; what I want is for a single instance to list all
open spreadsheets. The puzzling part is that the 'Windows in taskbar
box is still unchecked! I also opened my Personal xls and made sure
the box was unchecked there as well. It's almost as if there is a
default set by 2007 somewhere and is not controlled by the Tools/
Options/View dialog. I'm not real comfortable in the Registry,
although I did find a post by Gord Dibben (I think, apologies if I
misquoted) detailing Registering and deregistering versions that I
might try if all else fails.


Thanks much for any insight. John


I have tried de-registering and re-registering as suggested by Dave
Peterson in a response to a similar post (Sorry I mis-cited you
earlier) with no luck. I have also tried enabling 'Windows in taskbar,
followed by disabling the function, again with no luck. Seems like the
checkbox has no effect now. Looking for any other possible routes...


Thank you all for your suggestions, alas, no luck unfortunately. I
have "Ignore other apps" checked, re-registered (insuring I was
pointing at 2003 exe) and have the 2 versions loaded in different
directories. No joy. I'll keep looking and report back if I ever solve
this.

Attn Jim Rech, Your comment that the Windows in Taskbar option has
no effect puzzles me. What does it control in that case?

Thanks again all

John


Problem Solved!!

Had to do with the file association, not exactly sure what as I
changed it to launch 2003 when opening any *xls file, but anyway, I re-
associated xls to a Excel Worksheet, and in the Advanced dialog box,
there is a checkbox for "Browse in a single window" (or similar).
Credit here at this link

http://www.tech-archive.net/pdf/Arch...6/msg00355.pdf

Thanks All



All times are GMT +1. The time now is 06:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com