How to open 2 Excel documents on 2 screens?
Solved/Closed
lamuz85
Posted messages
29
Status
Membre
-
lolorhcp -
lolorhcp -
Hello,
I have a little problem, I have two screens for working.
Currently, when I open two Excel documents, they open in the same window (Excel session).
I would like to open these documents in two different Excel sessions so that I can have one document on each screen.
Currently, the solution of opening two blank Excel sessions and then opening the documents does not appeal to me.
Thank you for your help.
I have a little problem, I have two screens for working.
Currently, when I open two Excel documents, they open in the same window (Excel session).
I would like to open these documents in two different Excel sessions so that I can have one document on each screen.
Currently, the solution of opening two blank Excel sessions and then opening the documents does not appeal to me.
Thank you for your help.
13 answers
Hello,
There's a much simpler solution than going to delete things on the PC.
That's it
See you!
There's a much simpler solution than going to delete things on the PC.
- Open an Excel document
- Right-click on the Excel icon in the taskbar
- Click on Microsoft Excel, above "Pin to taskbar"
- Another Excel window opens where you can open another document
That's it
See you!
Modify the registry keys as follows:
First sequence
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
Second sequence
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
Now, if you double-click on two XLS or XSLX files on the desktop or in Explorer, they will open in two separate windows.
- Press [Windows]+[R], type REGEDIT, and click OK
First sequence
- Expand the key HKEY_CLASSES_ROOT \ Excel.Sheet.12 \ Shell \ Open
- Delete the DDEEXEC key by right-clicking it and selecting Delete
- Enter the COMMAND key
- Notice the presence of a value "(Default)" and a value "command"
- Right-click on the value "command" and choose Delete
- Double-click on the value "(Default)"
- Add a space followed by "%1" (with the quotes) at the end of the line so that the data looks like:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
Second sequence
- Expand the key HKEY_CLASSES_ROOT \ Excel.Sheet.8 \ Shell \ Open
- Delete the DDEEXEC key by right-clicking it and selecting Delete
- Enter the COMMAND key
- Notice the presence of a value "(Default)" and a value "command"
- Right-click on the value "command" and choose Delete
- Double-click on the value "(Default)"
- Add a space followed by "%1" (with the quotes) at the end of the line so that the data looks like:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
- Close REGEDIT
Now, if you double-click on two XLS or XSLX files on the desktop or in Explorer, they will open in two separate windows.
Hello, indeed thanks to the manipulation above I can now open 2 different windows in Excel, but then I have another problem, which is that when I open an Excel document directly by clicking on it, it opens in read-only mode and then I have issues modifying and saving... The only other way is to open Excel, go through "Open", find my file and then everything is fine, but it's much longer
can someone help me? Thanks.
can someone help me? Thanks.
Otherwise, you open the first file by double-clicking it, then you start Excel (Start Menu/Office/) by itself, and then you look for the second file through 'File/Open' and search for it in the directory of your drives.
The REAL solution is found at Microcrotte :D
http://support.microsoft.com/kb/2551928/en
And if you want the action to be default... don't forget to click the "Default" button in Folder Options>(.XLS and .XLSX)>Advanced> (Select "Open in a new window") and then the "Default" button.
Miracle... It works!!!!
Thank you who????....
http://support.microsoft.com/kb/2551928/en
And if you want the action to be default... don't forget to click the "Default" button in Folder Options>(.XLS and .XLSX)>Advanced> (Select "Open in a new window") and then the "Default" button.
Miracle... It works!!!!
Thank you who????....
To open two Excel files at the same time, you need to follow these steps:
1) Have two Excel files (logical)
2) Open one of the two Excel files and wait for its content to be displayed
3) Now open the Excel application again either via the shortcut on your desktop or directly in the program bar on your computer.
4) Now open your second file from this new Excel window. Simply go to File > Open... and navigate in the window to your file.
5) You now have two Excel files displayed at the same time!
If you've been looking for this tip for a long time, feel free to share it with those around you.
1) Have two Excel files (logical)
2) Open one of the two Excel files and wait for its content to be displayed
3) Now open the Excel application again either via the shortcut on your desktop or directly in the program bar on your computer.
4) Now open your second file from this new Excel window. Simply go to File > Open... and navigate in the window to your file.
5) You now have two Excel files displayed at the same time!
If you've been looking for this tip for a long time, feel free to share it with those around you.
Except that the process is quite long...
It is also possible to create a shortcut to open a new empty Excel session without a blank workbook opening: ""C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE" /e", but the process remains slow, as you still have to "browse for the file using the "open" menu in Excel. The ideal would be to be able to launch two separate Excel sessions without having to touch the Windows registry, simply by double-clicking on the files from the explorer, regardless of their extension (xlsx, xlsm, etc...)
There is indeed a small program that does this job, but it is only compatible with Excel 14 (2010), which is unfortunate for those still working with version 12 (2007) and are in a company, meaning they don't have administrative rights and therefore have no hope of even modifying the slightest registry key!
If you have the "chance" to own version 2014, you can download this small program (no installation) at the following address (all the developer's explanations are there): http://blog.aube-tech.com/2013/08/excel2session-ouvrir-ms-excel-dans-2-fenetres-differentes/
Best regards,
Phil
It is also possible to create a shortcut to open a new empty Excel session without a blank workbook opening: ""C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE" /e", but the process remains slow, as you still have to "browse for the file using the "open" menu in Excel. The ideal would be to be able to launch two separate Excel sessions without having to touch the Windows registry, simply by double-clicking on the files from the explorer, regardless of their extension (xlsx, xlsm, etc...)
There is indeed a small program that does this job, but it is only compatible with Excel 14 (2010), which is unfortunate for those still working with version 12 (2007) and are in a company, meaning they don't have administrative rights and therefore have no hope of even modifying the slightest registry key!
If you have the "chance" to own version 2014, you can download this small program (no installation) at the following address (all the developer's explanations are there): http://blog.aube-tech.com/2013/08/excel2session-ouvrir-ms-excel-dans-2-fenetres-differentes/
Best regards,
Phil
I'm taking the solution from an internet user that worked for me:
"mozisII wrote:
1 year later:
I found it! To open a new application (window) of Excel every time you double-click on an xls file:
* Folder options
* file types
* select "xls" SAME FOR "xlsx"
* advanced
* select "Open"
* Modify...
* Uncheck "Use DDE"
* At the end of the Application used line add "%1" (with quotes). The line becomes something like:
"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e "%1"
The difference is that for me I have /dde at the end and not /e, I simply added "%1" with a space and it worked
* OK
To revert back to the previous setting:
* Go to the modification of "open" for xls
* Remove the "%1" at the end
* Check DDE if it's not already the case
* enter in "DDE Message": [open("%1")]
And "
"mozisII wrote:
1 year later:
I found it! To open a new application (window) of Excel every time you double-click on an xls file:
* Folder options
* file types
* select "xls" SAME FOR "xlsx"
* advanced
* select "Open"
* Modify...
* Uncheck "Use DDE"
* At the end of the Application used line add "%1" (with quotes). The line becomes something like:
"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e "%1"
The difference is that for me I have /dde at the end and not /e, I simply added "%1" with a space and it worked
* OK
To revert back to the previous setting:
* Go to the modification of "open" for xls
* Remove the "%1" at the end
* Check DDE if it's not already the case
* enter in "DDE Message": [open("%1")]
And "
For Windows 7 with Office 2007 or 2010
You need to change the following registry keys.
HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\
Rename the key ddeexec to ddeexec.old
In the command key
Modify the command key by changing the /dde at the end of the line to /e "%1"
Do the same for the key
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\
Rename the key ddeexec to ddeexec.old
In the command key
Modify the command key by changing the /dde at the end of the line to /e "%1"
You need to change the following registry keys.
HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\
Rename the key ddeexec to ddeexec.old
In the command key
Modify the command key by changing the /dde at the end of the line to /e "%1"
Do the same for the key
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\
Rename the key ddeexec to ddeexec.old
In the command key
Modify the command key by changing the /dde at the end of the line to /e "%1"
Hello,
Here’s a method if you’re not the Administrator of your machine and therefore don’t have access to regedit, which is often the case at work!
Create a .bat file with the following line inside, adjusting the location of the Excel executable:
start "" "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" %1
And set the .xls, .xlsx, etc. Excel files to open with the previously created .bat file; they will launch in a new window.
There you go :)
Here’s a method if you’re not the Administrator of your machine and therefore don’t have access to regedit, which is often the case at work!
Create a .bat file with the following line inside, adjusting the location of the Excel executable:
start "" "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" %1
And set the .xls, .xlsx, etc. Excel files to open with the previously created .bat file; they will launch in a new window.
There you go :)
The Bat solution is very good. By redirecting the opening of xls files to Batch and adding an Excel icon, it's perfect.
The other solution, which involves opening a second Excel window, is what I used until now.
But I wanted to clarify: everyone seems to forget the middle click integrated into all mice nowadays.
Let me explain: once the first Excel file is open, by middle-clicking on the Excel icon in the taskbar, a new window opens. You just have to drag the second file to be opened into it. It's the same thing as mentioned above but with fewer clicks, fewer words, and easier to grasp for a beginner.
The other solution, which involves opening a second Excel window, is what I used until now.
But I wanted to clarify: everyone seems to forget the middle click integrated into all mice nowadays.
Let me explain: once the first Excel file is open, by middle-clicking on the Excel icon in the taskbar, a new window opens. You just have to drag the second file to be opened into it. It's the same thing as mentioned above but with fewer clicks, fewer words, and easier to grasp for a beginner.
Hello,
A solution to avoid complicating things by opening 2 instances and pulling from the 2nd file (which is problematic when it's attached to an email or on a website) or not having to tweak the registry is to install the app found here:
http://blog.aube-tech.com/2013/08/excel2session-ouvrir-ms-excel-dans-2-fenetres-differentes/
See you later!
A solution to avoid complicating things by opening 2 instances and pulling from the 2nd file (which is problematic when it's attached to an email or on a website) or not having to tweak the registry is to install the app found here:
http://blog.aube-tech.com/2013/08/excel2session-ouvrir-ms-excel-dans-2-fenetres-differentes/
See you later!
Thank you f894009, but as I told you, I am not going to do that for my 500 users.
Srg2, as explained above, I do not want to implement your solution.
We must consider that the user is "dimwitted"; explaining your manipulation to them will not satisfy them.
I will still test your solution f894009 on my workstation.
Srg2, as explained above, I do not want to implement your solution.
We must consider that the user is "dimwitted"; explaining your manipulation to them will not satisfy them.
I will still test your solution f894009 on my workstation.
Re,
In this case, you can do it from your workstation. To make your job easier, you will need to create a batch file that you will copy onto each PC as updates are made. This file will handle everything—creating directories, copying files, creating shortcuts on the desktop, and deleting the batch file at the end of the PC update.
It's a lot of work, but unless you have network administrators who normally have the means to automate this process more, it's up to you to do it.
For each new .XLS, it will be the same work; however, for updates to existing files, you can make the .XLS file a bit smarter by adding VBA to monitor a version file on the network for each document, and the file update will be automatic.
Good luck.
In this case, you can do it from your workstation. To make your job easier, you will need to create a batch file that you will copy onto each PC as updates are made. This file will handle everything—creating directories, copying files, creating shortcuts on the desktop, and deleting the batch file at the end of the PC update.
It's a lot of work, but unless you have network administrators who normally have the means to automate this process more, it's up to you to do it.
For each new .XLS, it will be the same work; however, for updates to existing files, you can make the .XLS file a bit smarter by adding VBA to monitor a version file on the network for each document, and the file update will be automatic.
Good luck.
Congratulations!
Am I allowed to say I love you?? Or would it be inappropriate? Once again, thank you, my hair thanks you too.