LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
3R''s
 
Posts: n/a
Default Can you open a new spreadsheet in a new program window?

The problem is that double-clicking a spreadsheet doesn't open a new instance
of Excel, it opens it in the current one. Then when you click the close "x"
in the upper right hand corner of the window, it closes ALL your workbooks,
not just the current one. This is not consistent with the way Word works
where opening a new Word document will open a whole new program window. Can I
change a setting to make Excel behave like Word?

I've tried this solution from to no avail:

"The answer involves changing 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. "
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open several workbooks in their own window Mak Excel Discussion (Misc queries) 5 October 9th 07 06:30 PM
How to set Excel to open a new window for each application Luke Excel Discussion (Misc queries) 1 September 28th 05 11:50 PM
How to open a spreadsheet with Macros disabled Mauricio Silva Excel Discussion (Misc queries) 6 March 24th 05 01:59 PM
How do I set Excel to auto open a document into a new Window even. dixiebee Excel Worksheet Functions 1 December 15th 04 09:28 PM
How do I force a hyperlink in a spreadsheet to open a new window? sq246 Excel Worksheet Functions 0 November 18th 04 10:53 PM


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"