#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default workbooks

I use to be able to keep more than one workbook open at a time. Now if I
close one they all close. How do I fix this.
Thanks
--
jranger
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default workbooks

My bet is you're clicking on that giant X in the top right corner. This closes
the application.

You want to use the X on the top right corner of the worksheet window--or use
File|Close.



jranger wrote:

I use to be able to keep more than one workbook open at a time. Now if I
close one they all close. How do I fix this.
Thanks
--
jranger


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default workbooks

You need to open the excel files from differentt windows. the way to do this
is to open a new excel window from the Start - Program Menu. Then using the
Open Menu Open you excel file. Repeat this for each excel file. If you open
the Excel file from your desk top all the files end up in the same excel
window. You can see if the files are in the same window by minimizing the
worksheets. All the books are in the same window.

"Dave Peterson" wrote:

My bet is you're clicking on that giant X in the top right corner. This closes
the application.

You want to use the X on the top right corner of the worksheet window--or use
File|Close.



jranger wrote:

I use to be able to keep more than one workbook open at a time. Now if I
close one they all close. How do I fix this.
Thanks
--
jranger


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default workbooks

I find that opening separate instances of excel causes me trouble when I want to
exchange data/formulas between different instances.

And I would think that it could have a significant impact on performance with
lots of instances of excel running.

Joel wrote:

You need to open the excel files from differentt windows. the way to do this
is to open a new excel window from the Start - Program Menu. Then using the
Open Menu Open you excel file. Repeat this for each excel file. If you open
the Excel file from your desk top all the files end up in the same excel
window. You can see if the files are in the same window by minimizing the
worksheets. All the books are in the same window.

"Dave Peterson" wrote:

My bet is you're clicking on that giant X in the top right corner. This closes
the application.

You want to use the X on the top right corner of the worksheet window--or use
File|Close.



jranger wrote:

I use to be able to keep more than one workbook open at a time. Now if I
close one they all close. How do I fix this.
Thanks
--
jranger


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default workbooks

Thanks
--
jranger


"Dave Peterson" wrote:

I find that opening separate instances of excel causes me trouble when I want to
exchange data/formulas between different instances.

And I would think that it could have a significant impact on performance with
lots of instances of excel running.

Joel wrote:

You need to open the excel files from differentt windows. the way to do this
is to open a new excel window from the Start - Program Menu. Then using the
Open Menu Open you excel file. Repeat this for each excel file. If you open
the Excel file from your desk top all the files end up in the same excel
window. You can see if the files are in the same window by minimizing the
worksheets. All the books are in the same window.

"Dave Peterson" wrote:

My bet is you're clicking on that giant X in the top right corner. This closes
the application.

You want to use the X on the top right corner of the worksheet window--or use
File|Close.



jranger wrote:

I use to be able to keep more than one workbook open at a time. Now if I
close one they all close. How do I fix this.
Thanks
--
jranger

--

Dave Peterson


--

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
Display 2 formulas from source workbooks to destination workbooks Excel_seek_help Excel Discussion (Misc queries) 4 April 27th 06 08:13 PM
suddenly my excel workbooks are "shared workbooks" Maggie's mom Excel Discussion (Misc queries) 1 August 28th 05 09:20 PM
How workbooks link to other workbooks Greg Excel Discussion (Misc queries) 4 August 11th 05 07:50 PM
Between Workbooks danielle Excel Discussion (Misc queries) 4 July 6th 05 09:30 PM
Using other workbooks.. DavidMunday Excel Worksheet Functions 1 June 28th 05 08:31 AM


All times are GMT +1. The time now is 12:04 AM.

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"