bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > General > Ignoring Other Applications

Ignoring Other Applications

Summary: If Excel is giving you problems when working with other applications, you may want to configure Excel so that it doesn’t share information with other programs. Using the Ignore Other Applications check box as described in this tip does the trick. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Normally, Excel works very well with other applications on your system--it is designed to do that. However, you may not want Excel to share information with other applications, for whatever reason. (Perhaps another application is interfering with the way you expect Excel to work.) If this is the case, then you may want to try this step:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the General tab is displayed. (Click here to see a related figure.)
  3. Select the Ignore Other Applications check box.
  4. Click OK.

With the check box selected, Excel won't share DDE information with other applications. (DDE is an acronym for Dynamic Data Exchange, and is the common basis for the way that many applications access the same data.) If you change the setting of the Ignore Other Applications check box, make sure you pay close attention to Excel's behavior--turning off the sharing can have unwanted consequences on the way you use Excel or other programs. Changing the setting won't affect the validity of the answers provided by Excel, it just changes the way that Excel works within the Windows environment.

Tip #3046 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


PivotTables Got You Perplexed? Learn the ins and outs of this powerful data-crunching tool. ExcelTips: PivotTables for the Faint of Heart makes it easy.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)