Showing posts with label Excel all file open in same windows. Show all posts
Showing posts with label Excel all file open in same windows. Show all posts

Friday, June 24, 2011

All files open in the same window in Microsoft Excel


Issue


I have a problem with Excel 2007. All my files open in the same window.

Solution

  • Go to explorer, choose tools, then folder options. Click the File Types tab.
  • Scroll down to the XLS extension. Click the Advanced button. Choose "open", then click the edit button.
  • At the end of the "Application used" entry, you'll probably see: /e
  • After this, add: "%1" (be sure to include the quotes.)
  • Then uncheck the "Use DDE" checkbox. Then click OK. (Windows re-checks it at some point for some reason, but it still works)
  • Click on OK
  • Now when you double-click a spreadsheet, it will open it in a new instance of Excel