Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JVC Dude
 
Posts: n/a
Default Can Excel open each workbook in a seperate window

My elderly father uses lots of Excel workbooks for different lists etc, but
with2 or 3 open they all open within '1 Excel program'. Can Excel be set
to open each workbook into its own window rather like Publisher or even
Internet Explorer?

It would enable easier+ more understandable switching between panes and
more importantly closing the prog/ 1 file without saving won't mean he
closes ALL without saving as has been the case- on more than 1 occasion
now..
Using Autosave isn't always the best method either since it then 'freezes'
the file stopping the ability to UNDO


regards
AW


  #2   Report Post  
 
Posts: n/a
Default

excel was designed to work the way it does.
the only suggestion i could make would be to open multiple
sessions of excel. but watch your memory usage.

-----Original Message-----
My elderly father uses lots of Excel workbooks for

different lists etc, but
with2 or 3 open they all open within '1 Excel

program'. Can Excel be set
to open each workbook into its own window rather like

Publisher or even
Internet Explorer?

It would enable easier+ more understandable switching

between panes and
more importantly closing the prog/ 1 file without saving

won't mean he
closes ALL without saving as has been the case- on more

than 1 occasion
now..
Using Autosave isn't always the best method either since

it then 'freezes'
the file stopping the ability to UNDO


regards
AW


.

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Try checking:

Tools|Options|General Tab|Ignore other applications (check it)

Then have your dad click on the excel shortcut (put another on his desktop???)
to start that second instance.

(He shouldn't use File|Open to open more than one workbook (in the same
instance).)

And be aware that turning this setting off sometimes gives errors with workbooks
that contain spaces in their path/name:

C:\my documents\excel\my book.xls

The error will look kind of like:
cannot find c:\my ..
then
cannot find documents\excel\my
then
cannot find book.xls



JVC Dude wrote:

My elderly father uses lots of Excel workbooks for different lists etc, but
with2 or 3 open they all open within '1 Excel program'. Can Excel be set
to open each workbook into its own window rather like Publisher or even
Internet Explorer?

It would enable easier+ more understandable switching between panes and
more importantly closing the prog/ 1 file without saving won't mean he
closes ALL without saving as has been the case- on more than 1 occasion
now..
Using Autosave isn't always the best method either since it then 'freezes'
the file stopping the ability to UNDO

regards
AW


--

Dave Peterson
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Can't open workbook (in Excel 2000) gcotterl Excel Discussion (Misc queries) 2 January 23rd 05 01:42 AM
The first workbook I open in excel causes book 1 to also be opene. manders Excel Discussion (Misc queries) 3 January 21st 05 06:16 PM
how to get excel to open in a new, and seperate window with each . Sonja at Work Excel Discussion (Misc queries) 1 January 4th 05 12:05 AM
How do I open each workbook in it's own version of Excel? RKOCT Excel Discussion (Misc queries) 3 December 9th 04 12:32 AM


All times are GMT +1. The time now is 11:35 AM.

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"