Annoyances.org
Home » Windows 2000 Discussion Forum » Message 1117039019 Search | Help | Home
  
re: Question about Excel and NOT closing all workbooks
Wednesday, May 25, 2005 at 9:36 am
Windows 2000 Annoyances Discussion Forum
Posted by Shawn (2 messages posted)


Important point here: ensure the " is around the %1 (so it looks like "%1") or it won't work, and excel will start trying to open each word up to any space as a separate file. Thanks though, that solved the issue. no more closing all excel files by mistake!


On Wednesday, May 25, 2005 at 8:11 am, Dave wrote:
>To make excel open each spreadsheet in a different instance, and thus only close
>the current one when you click the "x":
>
>change the file association stuff in windows. 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)
>
>
>OK your way out of the file types dialog.
>
>
>Now when you double-click a spreadsheet, it will open it in a new
>instance of Excel.
>
>
>Hope it helps!
>
>
>Dave
>
>
>
>
>


Written in response to:
re: Question about Excel and NOT closing all workbooks (Dave: Wednesday, May 25, 2005 at 8:11 am)

There are presently no replies to this message.

All messages in this thread [show all]
-Question about 'Force Office 2000 to Open All Documents in the Same Window' (R.de Zeeuw: Tue, Jan 28, 2003, 5:46 am)
-re: Question about Excel and NOT closing all workbooks (Shawn: Thu, Dec 18, 2003, 1:07 pm)
-re: Question about Excel and NOT closing all workbooks (Dave: Wed, May 25, 2005, 8:11 am)
*re: Question about Excel and NOT closing all workbooks (Shawn: Wed, May 25, 2005, 9:36 am)
-re: Question about Excel and NOT closing all workbooks (Mike: Wed, Jan 2, 2008, 1:46 am)
-re: Question about Excel and NOT closing all workbooks (Ville: Wed, Jan 16, 2008, 5:10 am)
*re: Question about Excel and NOT closing all workbooks (Steve: Mon, Apr 14, 2008, 6:29 am)
Return to the Windows 2000 Discussion Forum

All content at Annoyances.org is Copyright © 1995-2008 Creative Elementtm All rights reserved.
Please do not plagiarize; redistributing these pages without permission is strictly prohibited.