ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Can Excel open each workbook in a seperate window (https://www.excelbanter.com/setting-up-configuration-excel/5087-can-excel-open-each-workbook-seperate-window.html)

JVC Dude

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




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


.


Dave Peterson

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


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com