Solved

Open Excel in separate windows

Posted on 2014-03-24
1
646 Views
Last Modified: 2014-03-27
How can I configure Excel to always open each spreadsheet in a new window.  I DON'T WANT to open a new instance of Excel then point to a file on my PC.  I want to tell Excel to work like Word does, and simply launch each spreadsheet in a new window.  When I get a spreadsheet as an attachment, I want to click on it and open a new window.
0
Comment
Question by:MGothelf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 13

Accepted Solution

by:
Norm Dickinson earned 500 total points
ID: 39951024
To resolve this, go to 'excel options' > click on the 'advanced' tab > scroll down to general > check the ignore other applications that use 'Dyanamic Data Exchange (DDE)'

See http://answers.microsoft.com/en-us/office/forum/office_2010-excel/open-each-spreadsheet-in-a-new-instance-of-excel/8683864f-de1b-45ee-a519-c23a0e3a314b
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question