Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How can I get Excel to open a document in a new Window ? NEW QUEST

Office 2003. This was asked before, but the answer was for a different
question and (strangely) the questioner was happy. I really don't care about
icons in my task bar. I want each spreadsheet in a DIFFERENT WINDOW. So
that when I close one, ONLY THAT DOCUMENT IS CLOSED/SAVED. Another answer
gave me one way to do this: force separate instances of Excel with
Start-Run-"Excel", but now I have to navigate through (say) 15 directories
to find each document to open instead of just double-clicking. EVERY TIME I
have multiple documents open and attempt to close one of them by clicking the
go-away box on the Window (yes I know I can use the go-away box on the
sub-pane for the document, but this is different from EVERY OTHER PIECE OF
SOFTWARE IN EXISTENCE, so I always forget), the Save/Abandon question
probably actually refers to a non-current document, but I ALWAYS miss this,
because logically, it is the current document in front of me, and I don't
want to be asked questions about other documents. The result is that I lose
changes almost every time I have multiple documents open. Word uses this
paradigm, and Excel can physically do it, but can it be configured to do it
by default (when I double-click on the second .xls file) ?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default How can I get Excel to open a document in a new Window ? NEW QUEST

Try this:

Open Windows Explorer
Select "Tools"
Select "Folder Options"
Select the "File Types" Tab
Scroll down to find and select the XLS extension
Click the "Advanced" Button
Select the "Open" action from the list
Click the "Edit..." Button
Where is says "Application used to perform action:"
If not already there, add:

/e "%1"

to the end of the file path
Uncheck the "Use DDE" box
Click OK
Click OK
Click Close

That should do it.

HTH,
Elkar


"maysi01" wrote:

Office 2003. This was asked before, but the answer was for a different
question and (strangely) the questioner was happy. I really don't care about
icons in my task bar. I want each spreadsheet in a DIFFERENT WINDOW. So
that when I close one, ONLY THAT DOCUMENT IS CLOSED/SAVED. Another answer
gave me one way to do this: force separate instances of Excel with
Start-Run-"Excel", but now I have to navigate through (say) 15 directories
to find each document to open instead of just double-clicking. EVERY TIME I
have multiple documents open and attempt to close one of them by clicking the
go-away box on the Window (yes I know I can use the go-away box on the
sub-pane for the document, but this is different from EVERY OTHER PIECE OF
SOFTWARE IN EXISTENCE, so I always forget), the Save/Abandon question
probably actually refers to a non-current document, but I ALWAYS miss this,
because logically, it is the current document in front of me, and I don't
want to be asked questions about other documents. The result is that I lose
changes almost every time I have multiple documents open. Word uses this
paradigm, and Excel can physically do it, but can it be configured to do it
by default (when I double-click on the second .xls file) ?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How can I get Excel to open a document in a new Window ? NEW Q

WOW! I am impressed. I have to dash now but I will try this tomorrow.
THANK YOU! Let me know if you want to know anything about Ingres...

"Elkar" wrote:

Try this:

Open Windows Explorer
Select "Tools"
Select "Folder Options"
Select the "File Types" Tab
Scroll down to find and select the XLS extension
Click the "Advanced" Button
Select the "Open" action from the list
Click the "Edit..." Button
Where is says "Application used to perform action:"
If not already there, add:

/e "%1"

to the end of the file path
Uncheck the "Use DDE" box
Click OK
Click OK
Click Close

That should do it.

HTH,
Elkar


"maysi01" wrote:

Office 2003. This was asked before, but the answer was for a different
question and (strangely) the questioner was happy. I really don't care about
icons in my task bar. I want each spreadsheet in a DIFFERENT WINDOW. So
that when I close one, ONLY THAT DOCUMENT IS CLOSED/SAVED. Another answer
gave me one way to do this: force separate instances of Excel with
Start-Run-"Excel", but now I have to navigate through (say) 15 directories
to find each document to open instead of just double-clicking. EVERY TIME I
have multiple documents open and attempt to close one of them by clicking the
go-away box on the Window (yes I know I can use the go-away box on the
sub-pane for the document, but this is different from EVERY OTHER PIECE OF
SOFTWARE IN EXISTENCE, so I always forget), the Save/Abandon question
probably actually refers to a non-current document, but I ALWAYS miss this,
because logically, it is the current document in front of me, and I don't
want to be asked questions about other documents. The result is that I lose
changes almost every time I have multiple documents open. Word uses this
paradigm, and Excel can physically do it, but can it be configured to do it
by default (when I double-click on the second .xls file) ?

Reply
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
How can I open from Web Excel Files in a separate Window? KUR Excel Discussion (Misc queries) 0 March 27th 06 09:06 PM
Launch new browser window from an excel web page Hal Anderson Excel Discussion (Misc queries) 2 January 20th 06 02:10 AM
Cannot open excel inside word document SF Excel Discussion (Misc queries) 0 August 30th 05 09:12 PM
How do I set up Excel to open a new instance/application window w. DK9144 Excel Discussion (Misc queries) 1 February 21st 05 04:34 PM
excel cannot open .xls the document may be read only or encrypted mukesh Excel Discussion (Misc queries) 0 November 27th 04 12:35 PM


All times are GMT +1. The time now is 04:40 PM.

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

About Us

"It's about Microsoft Excel"