Solved

Excel in Win 7

Posted on 2012-04-06
3
262 Views
Last Modified: 2012-04-06
Hi, I need some help in getting one Excel workbook to show up on my monitor and the other on my laptop.  The first time I open an Excel workbook I dragged it over to my monitor.  I opened the second one and it displayed on my desktop which is what I want however, once I closed the workbooks and reopened them, they automatically went to my monitor and so did all subsequent workbooks that I opened.  They just piled up one on top of the other.  I tried to minimize one and it minimized all of them.  

Why would it do it the first time and not any others?  Is there a way to correct this? Thanks.
0
Comment
Question by:camtz
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
Treoctone earned 500 total points
Comment Utility
With one of the files open, right click on the Excel icon on the task bar and click on Microsoft Excel to open another instance. You can then open the other file you need in the new workbook.
0
 

Author Comment

by:camtz
Comment Utility
I'm afraid I jump the gun here.  I awarded you the points before I realized that your solution is not exactly what I need.  I would like to keep this going but don't know how.  

My Excel icon is not on the Taskbar but rather on the start menu.  I right clicked it and it opened up a "new instance" but I don't need a "new" workbook, I need to work with pre-existing workbooks on two different screens.  It would have been nice if it had allowed me to choose which workbook I wanted to open when I right clicked it instead of giving me a new one.  Is there any way we can leave this open so you can respond? Thanks.
0
 
LVL 4

Expert Comment

by:Treoctone
Comment Utility
It does not allow you to open an existing workbook from there, but you can click on the drop-down arrow and browse for the file you need to open. You will then be able to work with two books on different screens.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now