View two worksheets simultaneously.

[thalt]

Hi All
I use a two monitor setup driven from a Radeon 9550 graphics card, but the problem I have occurs on a single monitor as well.

When I open multiple workbooks or worksheets I can only view one at a time the other remains embedded behind the open window.

Nothing I know of will let me view both at the same time.

If there are two open worksheets full size on the screen and I minimize one they both minimize.

If I decide to close one workbook/sheet down all open workbooks/sheets close down as well.

My question/s

Can I view two workbooks at the same time? Can I close one down while keeping one open?

TIA thalt

[martindwilson]

try opening excel twice. and then open workbook in each of them

[JBeaucaire]

As far as I've seen, this needs to be fixed in your computer settings, not Excel.

1. Close Excel
2. Open My Computer
3. Go to Tools > Folder Options > File Types
4. Scroll down and choose XLS in the list of file types
5. Click on Advanced
6. Uncheck the Browse in same window box
7. In the Actions section, highlight Open
8. Click on Edit
9. Make sure in the Action box it says &Open
10. Make sure in the Application used to perform action it says:
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "%1"
11. Check the box next to Use DDE
12. Remove anything that is in DDE Message box and DDE Application Not Running box
13. Make sure the Application box says: Excel
14. In the Topic box it says: System
15. Click on OK > OK > Apply/Close to save your changes.

You've just taught your computer to open every new file in a separate window, a separate instance of Excel. Not sure you're going to like that. It bugs me sometimes, but I'm used to it by now.

Now open you file and click on a link to another file. It should open in another window. If you have Excel maximized, that might not be evident at first.

Since the windows are independent, put them where you want.

[thalt]

Thanks martindwilson that is a simple elegant solution that I never thought of.

and thanks JBeaucaire I would like to fix any 'rogue' computer settings in my PC, alas I must attend to a doctors appointment so I will not be able to test it until tonight (Australian time).

I will let you know how I make out. Thalt

[thalt]

Thanks to you both.
JBeaucaire your solution suits me perfectly. I construct and receive, workbooks and worksheets from others, as they all end up in the same folder it is quicker to be able to open, close or transfer between monitors at random.

Thanks again to you both, thalt.