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

[Guest]

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.

 

[pinmaster]

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

HTH
JG

 

[Guest]

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???

 

[Dave Peterson]

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.)

 

[Gord Dibben]

Try Tools>Options>General.

Checkmark "Ignore other applications".


Gord Dibben Excel MVP