open Excel 2007 spreadsheets in different windows on Vista
Posted by Jason Brundage in Microsoft Office, tags: Microsoft Office, Microsoft VistaThis is for Windows Vista only! If you are using Windows XP, please see open Excel 2007 spreadsheets in different windows on XP
Before you try the fix please read this first : There are times that this will not work… (I had a user run into this)… When I tested this I open the files in C:\temp and it worked fine. However, i f there are spaces in the path to the file then when you click on the Excel file a blank document will open up.
Other applications require DDE to communicate with Excel. So unless you have to have the functionally of double clicking on an Excel files and opening each file in it’s own instance, I would recommend using the features in Vista and Excel.
For example: When you launch Excel, Vista saves a list of the most recent applications used. If you click on Start, for example Excel will be listed if you have opened it recently.
Otherwise, go to the Office 2007 folder and launch Excel. And while you are in the folder, right click on Excel and select send to Desktop (create shortcut) . Now you have a desktop shortcut.
Click on the Excel desktop shortcut twice . You now have two windows opened.
Click on the Office 2007 button on each Excel document and open your Excel spreadsheets. If you do double click on a Excel file again (on the desktop for example), the first Excel Window that you opened will be the instance of Excel that the file will open in.
I now people wanted an Vista solution, so check back once in awhile because I will continue to work on a clean workaround on Vista.. Or you can ignore what I just recommended and try the fix anyways… Remember, if it does not work, no big deal just uncheck the box that will be discussed below.
In my last post on opening multiple worksheets or spreadsheets, the fix for this issue was specific to Windows XP only. On Microsoft Vista, you can not directly manager file types. Vista has tools to allow you to associate applications by using "open with", which is accessed by right clicking on a file and choosing what application you want to open for a specific file type.
Also I would like to comment that I have read on other web sites,9 many of them in fact) that Microsoft Excel 2007 does not use DDE. This is 100% wrong! Microsoft Excel 2007 use DDE on Windows XP and Windows Vista. This can be seen by monitoring the registry when opening Excel document. You can see that the DDE server is being used by Excel. I had to mention this because one of my annoyances in the IT field is when people share information that is not correct.
Fortunately the fix on Vista is a lot easier than the fix XP. The reason being Excel 2007 is intended to be installed on Vista not XP. Yes, I know Excel 2007 can be installed on XP, ( I use Office 2007 on another computer running XP). In a minute you will see one reason why I am saying this.
Solution:
- Open Microsoft Excel 2007 as you normally would. (it does not matter if you open an existing doment or create a new document.
- In the far upper left hand side of Excel 2007, left of the Menu item "Home ", you will see an Office 2007 button . It looks like this.
- Left Click on the Office 2007 button, and click on "Excel O ption s", just left of the "Exit E xcel" button.
- In the left pain, select Advanced
- On the right pain scroll all the way down, almost to the bottom, to the group "General’ , right after When calculating this workbook and before Lotus compatibility
- In the General group there is an option, Ignore other applications that use Dynamic Data Exchange (DDE) , select this option
- Click on OK
- Close Excel 2007
Open your first Excel 2007 workbook. Excel opens as usual.
Now open your second workbook. You will see another Excel 2007 window open up. This allows you to move your windows around so you can see both Excel files at the same time.
Back to my comment earlier about Excel 2007 intended for Vista.
On Windows XP, if you do the steps above and select the option Ignore other applications that use Dynamic Data Exchange (DDE) , Dynamic Data Exchange, Windows XP ignores this and continues to use DDE for Excel 2007. In Windows Vista, by selecting the option, Excel 2007 and Vista "cooperate" and turns off DDE.
Entries (RSS)
We currently have a setup with 2 monitors so using both to compare or drag and drop was nice in 2003, placing a check in ignore DDE still has both worksheets opening in the same excel window :-(
Ya I have seen this as noted in the original posting, if there are spaces in the path than this will not work by unchecking DDE.
What about trying the other work around… Is that feasible? ( as mentioned above)
Launch Excel twice, from start then click on Programs and then Microsoft Office.
Do not launch Excel initially by clicking on an XLS file. After you have Excel opened twice, than double click on an XLS file.
The first instance of Excel will be where your excel file will open. Then in the other Excel instance you will have to click on open within Excel and open an Excel spreadsheet. In order for this to work, you will have to have DDE checked…..
I know this is a pain, but until I figure out a “hack” or workaround, this is the best I can offer for now.. Check back to see if I have posted a more reliable workaround ….
Thank you, thank you! I have two monitors also, and this worked like a charm. I’ve been looking for this everywhere! Thanks!
To prevent new windows (instances) of Excel starting every time you open a new excel file, do the following for Vista
VISTA Solution:
1) Open Microsoft Excel 2007.
2) In the far upper left hand side of Excel 2007, left click the Office Menu Button.
3) Click on “EXCEL OPTIONS”, on bottom of box that opened when you pressed Office button.
4) In the left pain, click Advanced
5) Scroll down to you get the header “DISPLAY”
6) Make sure there is no check mark next to “SHOW ALL WINDOWS IN THE TASKBAR”
7) Click “OK”
and you should be set. Good luck.
Works as advertised on Vista Ultimate SP1 with Excel SP1- nice fix, good job!
Any solution for Windows 7 Enterprise and Excel 2007 SP2? Using the DDE fix results in an error box “There was a problem sending the command to the program”. It will allow me to open the files from within the excel menus in 2 windows/monitors but I cannot double click to open both xls and xlsx files until that box is unchecked.
Thanks, this was very helpful!
Another Question:
In Windows Vista, if the user wanted to have two files open side by side, they would open two Excel instances. To
target a particular window, they would simply give focus to the Excel instance in which they wanted the document to open. Double-clicking the attachment in Excel or Explorer would open the document in the window which last had
focus.
Now that we have upgraded to Windows Vista, this method no longer works. Launching a file by double-clicking the file always opens in the file in the first instance of Excel without regard for which Excel instance last had focus.
Does anyone know how to gain the same functionality as with Windows XP?
I am using XP with Office 2007. I tried to use the instructions for Xp but they didnt work for me. My system would not save changes I made, for example I would uncheck the DDE box and “ok” out but if I went back in it was checked again. I had added the “%1″ to the end of the file path but the window stripped the double quotes and now I cant delete the remaining %1. I am running into the same loop as with the DDE box. Now, checking the ignore DDE box in Excel options allows me to open two instances at a time but double clicking on excel files only opens empty an excel and I have to manually open files through the “open” command in excel.
Can anyone help?
Thank You!!! That works perfect with my two monitors! Thank you!
Sorry Melynda, which was the best solution ?
Regards
Pedro
This works if you are working on files that are pre-saved and or creating new files. It does not work if you are trying to open files from Outlook to view them. It actually doesn’t even open the file just excel to a blank window.
The best bet if you are using dual monitors is to expand excel across both screens and use the ‘View Side by Side’ option under View in the ribbon. You will probably need to click on ‘Arrange All’ and then select ‘Vertical’ to make it work.
Hope that helps.
Mike W.
Thanks this wonderfully works….