excell spread sheets

G

Guest

I have 2 spread sheets open. When I close one, they both close. How can I keep one open when I close the other one?
 
A

Andy Wiggins

How are you closing them?

Does Excel completely close at the same time?

Which version of Excel?

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Toni said:
I have 2 spread sheets open. When I close one, they both close. How can
Click to expand...
I keep one open when I close the other one?
 
G

Guest

I close them with the "X" at the top right hand corner
both spreadsheets close at the same time
I have Excel 2000
 
G

Guest

One reason might be the way you are closing either file. If you are using the 'X' in the uppermost right corner you are request that Excel close ALL open .xls

If you have multiple instances of excel open, look directly below the 'X' to find a second one adjacent to the help window. This closes only the xls you are in.
 
A

Andy Wiggins

The "X" in the top right hand corner closes Excel and, therefore, any open
workbooks.

Either use the "X" below the top right one or, better still, click on File >
Close.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Excel Spread Sheets 3
xlsx 1
open file by inputting file name in cell? 1
how do I sort excell files by date? 1
Replacement for multiple spreadsheets 3
Linking Spread Sheets 1
Combining spread sheets with common fields 3
New instance to Excell 1

Top