Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Need help setting Excel to display as I would like

08 May 2013   #11
eaglepi

Windows 7 ultimate SP1
 
 

Quote   Quote: Originally Posted by Kaktussoft View Post
If excel is already open, the new workbook opens in same excel window as you already saw. WORD doesn't! Powerpoint doesn't!

To open in seperate excel instance: open excel again from start menu and keep it opened. Now doubleclick on xls file. Now you have 2 seperate excel instances. You can displaye both if you want. Even side by side. Even on 2 monitors.

trick to solve it

Office Button > Excel Options > Advanced > General > Ignore Other appli.... ...(DDE)
Check this box. It is probably wise to uncheck it again before closing the last instance of excel...

Excel is still an MDI (Multiple Document Interface) application, while Word and PowerPoint have moved to a modified SDI (Single Document Interface) - the latter run only one instance of the application, but each document has its own application window. This is not possible in Excel.
You can start multiple instances of Excel, but that has several disadvantages:
  • It uses more resources.
  • Copying / pasting between separate instances is similar to copying / pasting between different applications, so some intelligent Excel features will not work.
Thanks for the added reply, I think now with both ways I will not have this problem any longer and once again thank all of you for the help
Ron


My System SpecsSystem Spec
.
08 May 2013   #12
eaglepi

Windows 7 ultimate SP1
 
 

Quote   Quote: Originally Posted by Kaktussoft View Post
Quote   Quote: Originally Posted by eaglepi View Post
Quote   Quote: Originally Posted by Kaktussoft View Post
If excel is already open, the new workbook opens in same excel window as you already saw. WORD doesn't! Powerpoint doesn't!

To open in seperate excel instance: open excel again from start menu and keep it opened. Now doubleclick on xls file. Now you have 2 seperate excel instances. You can displaye both if you want. Even side by side. Even on 2 monitors.

trick to solve it

Office Button > Excel Options > Advanced > General > Ignore Other appli.... ...(DDE)
Check this box. It is probably wise to uncheck it again before closing the last instance of excel...

Excel is still an MDI (Multiple Document Interface) application, while Word and PowerPoint have moved to a modified SDI (Single Document Interface) - the latter run only one instance of the application, but each document has its own application window. This is not possible in Excel.


You can start multiple instances of Excel, but that has several disadvantages:
  • It uses more resources.
  • Copying / pasting between separate instances is similar to copying / pasting between different applications, so some intelligent Excel features will not work.
Thanks for the added reply, I think now with both ways I will not have this problem any longer and once again thank all of you for the help
Ron
Glad you solved it. Why you think my name is Ron?
my name is Ron also and I was just signing my post with my name to thank you guys and make it a bit more personal.
My System SpecsSystem Spec
Reply

 Need help setting Excel to display as I would like




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
How to revert the setting of Excel 2010 to its default
Hi, When someone changes the settings of a Microsoft Excel 2010 file, how to recover its default settings? I've used Microsoft Fixit tool and also repairing the Office from Uninstall or change a program. Both didn't worked!
Microsoft Office
Display not refreshed when scrolling excel spreadsheet
Help, my excel spreadsheets (not large) do not display properly when I scroll. Some lines repeat, other do not refresh. I minimize the window then maximize it, and it displays OK, but after when I scroll, Excel does not refresh or update the cells properly. The worst case is having a screen...
Graphic Cards
Excel 97 display distorted in Win7
I've got 3 Windows 7 netbooks & 1 Win 7 laptop. When installing Office 97 on them I get mixed results. All looks fine during the installation. But once the initial reboot happens, the cells in the Excel sheets are more square and compact that the usual cells (see screenshot) . On one of the...
Microsoft Office
Office 2007Word/ Excel wil not display Help Menu
I am running Office 2007 (in x86) on Windows 7 and when I try to open the Help menu in Word or Excel I first get a dialog box that asks me if I want to save a file called transitions.htm. No matter if I say Save or Cancel the Help box opens blank. It says it is "connnected to Office Online," but...
Microsoft Office
Excel 2000 display issues
Has anyone encountered this issue before with Excel 2000 in Windows 7 (professional 32bit). We are testing windows 7 on some Pc, and those users are using Office 2000. Everything works fine, however, sometimes users launch excel (by double clicking on an XLS file) and excel come up like the...
Microsoft Office
Troubleshoot on VM Display setting
Hi, at first I wasn't sure were to place that thread. So I'm sorry if its wrong here. I need to know were I can change the "Hardware Beschleunigung" (I guess its called "hardware acceleration" or "hardware speedup"). I hoped to find it within the display settings > advanced > troubleshoot...
Virtualization


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:18.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App