how to re-set excel2000 to open a second instance in a separate wi
 

Hi Gang!

I opened a spreadsheet from a friend and it changed my excel2000 settings.

Formerly, when I opened a 2nd spreadsheet, it opened a separate excel
window. Now all of my spreadsheets open in one window - very annoying!

I know how to force it, (start-run-excel) but I want to re-set excel2000 to
'automatically' open 2nd workbooks in a new window - like when I doubleclick
a workbook from my desktop, for example.

Help!
Thanks,
..James.

how to re-set excel2000 to open a second instance in a separate wi
 

Hi,
Try Tools/Options/View and check "Windows in taskbar"

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=492531

how to re-set excel2000 to open a second instance in a separat
 

Thanks, but I do already have that selected, and I do see a separate taskbar
buttons for each workbook open, it's just that all the workbooks are in the
one Excel window rather than a separate window for each.

I can no longer open a 2nd instance of Excel, (nor a 2nd window for the 2nd
workbook), as used to happen automatically, before the properties of an
imported spreadsheet somehow changed my settings.

Can anyone help???

"pinmaster" wrote:


Hi,
Try Tools/Options/View and check "Windows in taskbar"

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=492531

how to re-set excel2000 to open a second instance in a separate wi
 

You really want a second instance of excel?????

This may help (or hurt).

You could try:

Tools|options|General tab|Ignore other applications (check it)

Then double click on the workbook in windows explorer.

And be aware that turning this setting on sometimes gives errors with workbooks
that contain spaces in their path/name:

C:\my documents\excel\my book.xls

The error will look kind of like:
cannot find c:\my ..
then
cannot find documents\excel\my
then
cannot find book.xls

Or it may just open excel and not show you the file that you clicked on.

(I'd just start another instance and then file|open the workbook.)

TorontoJames wrote:

Hi Gang!

I opened a spreadsheet from a friend and it changed my excel2000 settings.

Formerly, when I opened a 2nd spreadsheet, it opened a separate excel
window. Now all of my spreadsheets open in one window - very annoying!

I know how to force it, (start-run-excel) but I want to re-set excel2000 to
'automatically' open 2nd workbooks in a new window - like when I doubleclick
a workbook from my desktop, for example.

Help!
Thanks,
.James.

--

Dave Peterson

how to re-set excel2000 to open a second instance in a separat
 

Try ToolsOptionsGeneral.

Checkmark "Ignore other applications".


Gord Dibben Excel MVP

On Sun, 11 Dec 2005 21:00:02 -0800, TorontoJames
wrote:

Thanks, but I do already have that selected, and I do see a separate taskbar
buttons for each workbook open, it's just that all the workbooks are in the
one Excel window rather than a separate window for each.

I can no longer open a 2nd instance of Excel, (nor a 2nd window for the 2nd
workbook), as used to happen automatically, before the properties of an
imported spreadsheet somehow changed my settings.

Can anyone help???

"pinmaster" wrote:


Hi,
Try Tools/Options/View and check "Windows in taskbar"

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=492531