But.she has been doing it, for years, in Excel 2010, until that behavior suddenly changed at some point this afternoon. Is there anything else I can do with this? Everything I've read on this issue says Excel 2010ĭoesn't support running multiple instances like that, and that we shouldn't have been able to do it in the first place, and that upgrading to 2013 or higher would fix it. When I do that, she can't even open the spreadsheets at all and gets "There was a problem sending the command to the program" upon trying. I've tried going into Excel Options -> Advanced and checking the "Ignore other applications that use Dynamic Data Exchange (DDE)" option (as some suggested as a fix when I started searching). Which works and has the two files in different windows, but she doesn't see that as an acceptable workaround and gives me the "But I never had to do that before!" line (and I guess I have to admit that she has a point there). I have found that it's possible for her to just open the Excel File 1 by double clicking it as she has been, then opening Excel.exe from her start menu or whatever (to just open Excel itself without opening a file), then going to File->Open, navigating to her desktop, and selecting Excel File 2. I can do a side-by-side view of the two files or resize them and stack them on top of each other within that window, but she doesn't like that option because she can't really take advantage of her dual monitors that way (not to mention the two files are a lot smaller if she looks at them in that view).
So basically, she can't split them between her two monitors anymore. She can drag that one window around, but all her spreadsheets are "stuck" in that window. So the two different Excel files are inside one window. Now when she opens multiple Excel files that way (regardless of how many), they all open in what appears to be the same instance/window of Excel (only one excel.exe instance in task manager), and she can only see them confined to the same window (meaning she can't have Excel File 1 on this monitor and Excel File 2 on that monitor). She can no longer do that as of some point this afternoon. She could drag Excel File 1 to monitor 1 and Excel File 2 to monitor 2 and have them side by side, which is exactly what she wanted to do. They would each open in separate Excel instances/windows. Until today, she could simply open the files one at a time by double clicking them on the desktop. She has various Excel spreadsheets on her desktop (to keep things simple for this example, we'll just keep it down to two and go with Excel File 1 and Excel File 2).
Always open excel file in new window windows#
So I have an Excel 2010 (on Windows 7) user with dual monitors.
0 kommentar(er)
