Opening Doc's in a new Window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

-- Paul -- - 20 Jun 2007 12:04 GMT

Hi,

Currently when I am viewing a spreadsheet in excel and I want to open a
different spreadsheet they open in the same window which I find awkward. I
would prefer for the 2nd spreadsheet I open to start a new instance of excel
so I can flick between the two on the taskbar. Is there a setting that
controls this?. I'm using Excel 2003 on XP Pro.

Thanks

Paul

Reply to this Message

Earl Kiosterud - 20 Jun 2007 12:26 GMT

Paul,

Tools - Options - View, Windows in Taskbar

Signature

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> Hi,
>
[quoted text clipped - 6 lines]
>
> Paul

Reply to this Message

-- Paul -- - 20 Jun 2007 12:35 GMT

> Paul,
>
[quoted text clipped - 10 lines]
>>
>> Paul

Thanks for the prompt reply. I don't think I explaned myself too well as
that option is already checked. I need a totally separate instance of excel
to open for each spreadsheet I open. This used to happen on my old PC.
For example, if I open 3 spreadsheets I want them to each open in new excel
windows. I have dual monitor and I want to have one version of excel on one
monitor and one on the other.

Thanks

Reply to this Message

Dave Peterson - 20 Jun 2007 13:07 GMT

This may work...

You can change this setting:
Tools|Options|General tab|Ignore other applications (check it)

Be aware that one side effect of having this setting checked is sometimes you
can't open a file by double clicking on it in explorer. (toggle it back and
that should be fixed.)

This shows up for workbooks that have spaces in their name or path:
c:\my documents\excel\testworkbook.xls
or
c:\test of workbook2.xls

Cannot find C:\my, then more "Cannot find ..." messages.

It's more trouble than it's worth (for me, anyway).

If I want a second instance of excel, I'll just use:
windows start button|run
excel
then file|Open to open my file.

But I rarely want separate instances of excel.

> Hi,
>
[quoted text clipped - 7 lines]
>
> Paul

Signature

Dave Peterson

Reply to this Message

-- Paul -- - 20 Jun 2007 14:14 GMT

That's fixed it, thank you Sir.

> This may work...
>
[quoted text clipped - 36 lines]
>>
>> Paul

Reply to this Message

JohnR - 20 Jun 2007 14:31 GMT

Open both workbooks, then right click on a blank area of the taskbar.
Select "tile windows vertically". This may give you what you want.

> Hi,
>
[quoted text clipped - 7 lines]
>
> Paul

Reply to this Message

Rate this thread: