I used to be able to open two or more excel windows but now that I started
using macros I can no longer open separate windows. Everything shares the
same window. I guess this is due to the mysteries of PERSONAL.XLS but is
there any way to get back to being able to open separate windows?

Not clear what is needed. Try
1) Tools | Options; open View tab and check Windows in Taskbars
or
2) Windows | Arrange - tiled, etc

Or tell us what exactly is meant by "to be able to open two or more excel
windows"
best wishes


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"grok" wrote in message
...
I used to be able to open two or more excel windows but now that I started
using macros I can no longer open separate windows. Everything shares the
same window. I guess this is due to the mysteries of PERSONAL.XLS but is
there any way to get back to being able to open separate windows?

Thanks for replying, Bernard. Please see below:

"Bernard Liengme" wrote:

Not clear what is needed. Try
1) Tools | Options; open View tab and check Windows in Taskbars

I already had this checked and I see two excel tasks in the taskbar. But
clicking on either of them just changes what is in the one excel window.

or
2) Windows | Arrange - tiled, etc

The Tiled box was also checked. But I noticed a "Windows of active
workbook" box and checked it and that appears to have fixed my problem.
Thanks.



Or tell us what exactly is meant by "to be able to open two or more excel
windows"
best wishes


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"grok" wrote in message
...
I used to be able to open two or more excel windows but now that I started
using macros I can no longer open separate windows. Everything shares the
same window. I guess this is due to the mysteries of PERSONAL.XLS but is
there any way to get back to being able to open separate windows?

It doesn't exactly work. Now I get two windows inside one and can manuver
them side-by-side like I want but what I really want is two windows. I
should point out that these are .csv files and I'm opening them by clicking
on them in Windows explorer.

"grok" wrote:

Thanks for replying, Bernard. Please see below:

"Bernard Liengme" wrote:

Not clear what is needed. Try
1) Tools | Options; open View tab and check Windows in Taskbars

I already had this checked and I see two excel tasks in the taskbar. But
clicking on either of them just changes what is in the one excel window.

or
2) Windows | Arrange - tiled, etc

The Tiled box was also checked. But I noticed a "Windows of active
workbook" box and checked it and that appears to have fixed my problem.
Thanks.



Or tell us what exactly is meant by "to be able to open two or more excel
windows"
best wishes


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"grok" wrote in message
...
I used to be able to open two or more excel windows but now that I started
using macros I can no longer open separate windows. Everything shares the
same window. I guess this is due to the mysteries of PERSONAL.XLS but is
there any way to get back to being able to open separate windows?

Open one of the files via Explorer.

Now open EXCEL the application and load the seconf file into there.

Now resize the Window panes.

Jonah
===========
grok wrote:

It doesn't exactly work. Now I get two windows inside one and can manuver
them side-by-side like I want but what I really want is two windows. I
should point out that these are .csv files and I'm opening them by clicking
on them in Windows explorer.

Jonah, that doesn't help. It just puts me back into sharing the same window
with two spreadsheets.

"Jonah" wrote:

Open one of the files via Explorer.

Now open EXCEL the application and load the seconf file into there.

Now resize the Window panes.

Jonah
===========
grok wrote:

It doesn't exactly work. Now I get two windows inside one and can manuver
them side-by-side like I want but what I really want is two windows. I
should point out that these are .csv files and I'm opening them by clicking
on them in Windows explorer.