|
|
|
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
>
>
>
>
>
|
All messages in this thread [show all]
 |  |  |  | re: Question about Excel and NOT closing all workbooks (Shawn: Wed, May 25, 2005, 9:36 am) |
| |
| |
Return to the Windows 2000 Discussion Forum
|
|
|
|