In the second instance of Excel, use File, Open to open the workbook again. Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. The chapter on the logic behind arrays has been expanded.
July 07, - by Bill Jelen. CSV files as well. Have Fun, and please share this answer with others. And browse to the batch file you just created. You may want to tick "always use the selected program to open this kind of file". The way to get rid of that is to create an exe file from your batch file : use BatToExeConverter Freeware, dead easy to use : select 'invisible application' and the icon you want to use for your excel files.
Then, use the 'Open with' trick with your exe file. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 9 months ago. Active 8 years, 6 months ago. Viewed 76k times. Improve this question. Ritesh Ritesh 4 4 gold badges 10 10 silver badges 19 19 bronze badges. Can you not just open two instances of Excel and drag one onto the other screen?
Or am I missing something? No I tried that. No, Justmesayin is completely right. The answer given is completely not helpful to me or anyone else who actually wants to know the real answer to the question. I doubt anyone who posted here even tried to find a way around this themselves but instead justed openly guessed, or didn't read the question. Saturday, November 20, PM. Well, I have to admit the information on this was usefull to me and realized there was more that I needed to learn so I have two other ways to help that may be useful First my users wanted to open more than one excel app for each screen but also to twart any problems if a spreadsheet failed and they had to close the entire program for the other sheets that were not saved.
Tuesday, November 30, PM. Thursday, February 10, PM. If anyone can do this, please put some screenshoots and show the way step by step.. Sunday, February 20, AM. Until later Wednesday, February 23, PM.
Proposed as answer by mstewar78 Wednesday, June 8, PM. Tuesday, March 8, PM. My issue with this is, yes you can open two separate instances of Excel and open at the same time using this method. However if you have to compare data between the two workbooks, then you're out of luck. I have situations on a daily basis where I have to compare cell values all the time on very large spreadsheets.
It would make life so much easier Which is suppose to be the point of technology I will try the option of enlarging a single instance across both monitors that "Pieter Janssen" posted first to see if this will do. MS should have included a "Pop Out Window" feature that will allow you drag this new window to another monitor.
Thursday, March 31, PM. Tuesday, May 31, PM. Hold down the Ctrl key when you open the second instance of Excel. Proposed as answer by petar. You're welcome. Glad to help. Wednesday, June 1, AM. Hey all, First let me say, I am not on a Mac, that is a family nickname. LOL Any Help would be great. Wednesday, July 13, PM. Proposed as answer by Michael A. Repucci Wednesday, December 19, PM. Tuesday, July 26, PM. I know this post is old and that you are frustrated so hopefully my response helps.
To open 2 DIFFERENT excel documents in different Excel windows that can be seen on multiple monitors, read the all the steps below first than do them exactly as described and it should work. Good luck!!! Tuesday, August 9, PM. Anyone have a solution to the same issue? Thursday, September 22, PM. Hi There, I had the same problem, have only scanned the results below, saw someone loosing his calm a wee bit, if the question is how to open two seperate files, one on one moniter and one on the other?
Tuesday, December 6, PM. Don't click on the above link, It is a spyware site and you will get infected. Monday, December 12, PM. It also works in Win7 bits with Office Friday, February 3, PM. Monday, February 6, PM. Windows Registry Editor Version 5. Tuesday, February 7, PM. Just drag it. You could open another Excel and drag the file to it. Wednesday, April 11, PM.
Studies have shown that having an additional monitor increases the productivity by 20 to 30 percent Source: NY Times But some applications like MS Office Excel, even though you open multiple files, they are all from the same instance of the application. Option B : They key here is, the application has to be loaded as separate instances. Thursday, April 19, AM. Running Multiple Instances of Excel Be careful in changing the settings, could cause problems.
Proposed as answer by gcallantii Monday, August 12, PM. Friday, April 20, PM. Wednesday, May 9, PM. I think the problem was in opening two instances. Your suggestion states to "simply open two instances" and drag one to each monitor. I used to be able to do this in earlier versions of Excel but can no longer do so with The link you provided is for so I'm not sure what the story is for I did have luck one time but I don't know what I did so it is possible.
I have been able to do it going through the start menu but that's a bit clunky. Both work like a charm. Thank you! How do you enlarge a single instance across two monitors? I too have the same issue. I link a number of spreadsheets and I can't connect cells from spreadsheets in separate instances of excel.
Worked perfectly with the above directions. Life saver. Friday, May 25, PM. Worked perfectly! Thanks for the very clear instructions! Friday, August 17, PM. Friday, August 24, AM. A real "duh" moment that I didn't figure this out sooner too Thanks Scotslad!!!! Monday, August 27, PM. Thanks so much for that Tuesday, September 4, PM. Thanks, that worked for me! Friday, September 28, PM. Tuesday, November 27, PM. Repucci 0.
In my opinion, this is the best solution to this problem. Thanks Colin! Wednesday, December 19, PM. Wednesday, January 9, PM. Worked great! Monday, February 4, PM. Saturday, July 6, PM. Thanks again! Monday, August 12, PM. Tuesday, September 24, AM. The easy way to open two or more excel files separately. This is what works for me just figured it out : 1.
Create shortcut on Desktop 2. Open your first Excel file and place it on the screen you want 3. Open a new Excel file from the Excel icon on Desktop 4. Drag it to the other screen 5. Two separate screens. Thursday, October 31, AM. Thanks sooo very much - been wanted to use this for days :. Sunday, November 3, AM. Take Care. Friday, November 8, PM. Monday, November 11, PM.
Thursday, November 21, PM. Thank you, i success following this instructions. Really good. Tuesday, December 3, AM. I took this from another site, it worked for me in XP. Run regedit first. Ok, this will be slightly complicated If something breaks I don't take responsibility! Here's a screenshot of the final way it should look note that my excel install directory will likely be different than yours : Once you do this, you should be able to double-click on excel files, and each one will open in a new window.
Friday, December 6, PM. Thank you Dale, it works for me. It is really appreciated. Cheers, Mike. Monday, December 23, PM. Click here then click there - right-click left-click hold down the CTRL key What happened to the ol 'click a file's icon it opens the file, click a different file's icon, it opens that file in another window', and why is it so bloody hard to restore this functionality? Microsoft you never fail to disapoint, just sayin.. Friday, January 3, PM. Thank you so much, Dale.
I can do it successfully. Regards, Nay. Friday, January 10, AM. I do want to thank those who share. Monday, January 13, PM. Thursday, January 16, PM. Friday, January 17, AM. Thanks for posting this.
You just saved me a good amount of time of searching for an answer. Thursday, February 6, PM. Thanks, simple enough and works for me Friday, February 28, PM. Wednesday, March 5, AM.
This is a workaround and is not a seamless automated transition from default. Saturday, April 5, PM. Dear Friend, thank you very much , this is very useful advice. Thursday, June 12, AM. Sunday, June 29, AM. Tuesday, July 1, AM. Everyone else should delete their responses.
Monday, July 14, PM. My understanding is that this is not a Windows version issue, it is a problem with Excel that they have recently fixed Excel I was able to get it open twice, on separate screens and with separate close functions, by holding down the alt key and right clicking on my pinned Excel icon.
You then select the excel icon in the list mine is Excel and a new instance opened right up. I found the instructions granted for on the Office Blogs site and made it work. Hope this helps anyone who's still looking for answers. Tuesday, July 22, PM. Thank you, Sir C Mac - Works a treat!
Just a typo in both 'Left column:' lines. Should be command not commend Cheers Max.
0コメント