A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Closing all worksheets in excel 07



 
 
Thread Tools Display Modes
  #1  
Old December 28th, 2009, 01:22 AM posted to microsoft.public.excel.setup
DJT[_2_]
external usenet poster
 
Posts: 4
Default Closing all worksheets in excel 07

I have just upgraded from 2003 to 2007 office at the same time as
getting new computer with Windows 7.

I have eventualyl located the commands on the ribbon but I have one
problem

with Excel 2003 when I clicked on the X in the top right hand corner
of Excel it closed all the open workbooks.
I could use the X at the top right hand corner of the actual
worksheet to close cuurent one only.


With 2007 when I use the main X it only closes the current and not all
open worksheets

According to help it is supposed to close all open worksheets the same
as 2003 but this does not happen.


Has anyone got any ideas how to fix this or is it a new " feature"

DJT
  #2  
Old December 28th, 2009, 10:24 AM posted to microsoft.public.excel.setup
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Closing all worksheets in excel 07

Hi DJT I do not see the problem that you seem to be seeing in EXCEL 2007.

If I open a file that has 10 tabs and then click on the X in the far top
right hand corner I get a warning (Do I want to save changes etc - even
though I have not made any) which, if I select no, brings down the whole
EXCEL session.

If my comments have helped please hit Yes.

Thanks.





"DJT" wrote:

I have just upgraded from 2003 to 2007 office at the same time as
getting new computer with Windows 7.

I have eventualyl located the commands on the ribbon but I have one
problem

with Excel 2003 when I clicked on the X in the top right hand corner
of Excel it closed all the open workbooks.
I could use the X at the top right hand corner of the actual
worksheet to close cuurent one only.


With 2007 when I use the main X it only closes the current and not all
open worksheets

According to help it is supposed to close all open worksheets the same
as 2003 but this does not happen.


Has anyone got any ideas how to fix this or is it a new " feature"

DJT
.

  #3  
Old December 28th, 2009, 10:34 AM posted to microsoft.public.excel.setup
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Closing all worksheets in excel 07

I have just conducted a further test with 2 multiple tab Workbooks open in
one EXCEL session.

Clicking on X in the far top right hand corner will bring down both
Workbooks (one by one) and the session as well so what you say:-

"With 2007 when I use the main X it only closes the current and not all
open worksheets"

- does not seem to be 100% correct.

Please hit Yes if my comments have helped.

Thanks.

"DJT" wrote:

I have just upgraded from 2003 to 2007 office at the same time as
getting new computer with Windows 7.

I have eventualyl located the commands on the ribbon but I have one
problem

with Excel 2003 when I clicked on the X in the top right hand corner
of Excel it closed all the open workbooks.
I could use the X at the top right hand corner of the actual
worksheet to close cuurent one only.


With 2007 when I use the main X it only closes the current and not all
open worksheets

According to help it is supposed to close all open worksheets the same
as 2003 but this does not happen.


Has anyone got any ideas how to fix this or is it a new " feature"

DJT
.

  #4  
Old December 28th, 2009, 08:59 PM posted to microsoft.public.excel.setup
DJT[_2_]
external usenet poster
 
Posts: 4
Default Closing all worksheets in excel 07

What you are seeing is what is supposed to happen.

When I do it, I get asked 'do I want to save xxxx.xlsx'.
When I answer yes, it still leaves the other worksheets open.
With Excell 2003 the question would have an option to close all
worksheets, but I don't get that with 2007

DJT
On Mon, 28 Dec 2009 01:34:01 -0800, trip_to_tokyo
wrote:

I have just conducted a further test with 2 multiple tab Workbooks open in
one EXCEL session.

Clicking on X in the far top right hand corner will bring down both
Workbooks (one by one) and the session as well so what you say:-

"With 2007 when I use the main X it only closes the current and not all
open worksheets"

- does not seem to be 100% correct.

Please hit Yes if my comments have helped.

Thanks.

"DJT" wrote:

I have just upgraded from 2003 to 2007 office at the same time as
getting new computer with Windows 7.

I have eventualyl located the commands on the ribbon but I have one
problem

with Excel 2003 when I clicked on the X in the top right hand corner
of Excel it closed all the open workbooks.
I could use the X at the top right hand corner of the actual
worksheet to close cuurent one only.


With 2007 when I use the main X it only closes the current and not all
open worksheets

According to help it is supposed to close all open worksheets the same
as 2003 but this does not happen.


Has anyone got any ideas how to fix this or is it a new " feature"

DJT
.

  #5  
Old December 28th, 2009, 10:17 PM posted to microsoft.public.excel.setup
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Closing all worksheets in excel 07

lJT there is a Help topic called:-

Close workbooks or workbook windows

Search on the above to get a full Microsft explanation.

Please hit Yes if my comments have helped.

Thanks.

"DJT" wrote:

I have just upgraded from 2003 to 2007 office at the same time as
getting new computer with Windows 7.

I have eventualyl located the commands on the ribbon but I have one
problem

with Excel 2003 when I clicked on the X in the top right hand corner
of Excel it closed all the open workbooks.
I could use the X at the top right hand corner of the actual
worksheet to close cuurent one only.


With 2007 when I use the main X it only closes the current and not all
open worksheets

According to help it is supposed to close all open worksheets the same
as 2003 but this does not happen.


Has anyone got any ideas how to fix this or is it a new " feature"

DJT
.

  #6  
Old December 29th, 2009, 03:59 PM posted to microsoft.public.excel.setup
Shailesh Shah[_2_]
external usenet poster
 
Posts: 31
Default Closing all worksheets in excel 07

It is a new feature in Excel-2007.
To quit from Excel, double click on big office button on top left corner.

Regards,
Shailesh Shah
http://shahshaileshs.web.officelive.com/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://shahshaileshs.web.officelive.com/MenuAddins.aspx

Free Exshail Classic Menu for Excel-2007
http://shahshaileshs.web.officelive....ssic_Menu.aspx

"DJT" wrote in message
...
I have just upgraded from 2003 to 2007 office at the same time as
getting new computer with Windows 7.

I have eventualyl located the commands on the ribbon but I have one
problem

with Excel 2003 when I clicked on the X in the top right hand corner
of Excel it closed all the open workbooks.
I could use the X at the top right hand corner of the actual
worksheet to close cuurent one only.


With 2007 when I use the main X it only closes the current and not all
open worksheets

According to help it is supposed to close all open worksheets the same
as 2003 but this does not happen.


Has anyone got any ideas how to fix this or is it a new " feature"

DJT



  #7  
Old December 30th, 2009, 03:14 AM posted to microsoft.public.excel.setup
DJT[_2_]
external usenet poster
 
Posts: 4
Default Closing all worksheets in excel 07

I did look at the help 'Close Workbooks or workbook windows" and it
states that ' To close all workbooks that are open, you can close the
Excel window or exit Excel.'

My problem is that close the Excel window is what does not work. I can
gotto exit Excel and that closes all the windows but the other does
not work

DJT

On Mon, 28 Dec 2009 13:17:01 -0800, trip_to_tokyo
wrote:

lJT there is a Help topic called:-

Close workbooks or workbook windows

Search on the above to get a full Microsft explanation.

Please hit Yes if my comments have helped.

Thanks.

"DJT" wrote:

I have just upgraded from 2003 to 2007 office at the same time as
getting new computer with Windows 7.

I have eventualyl located the commands on the ribbon but I have one
problem

with Excel 2003 when I clicked on the X in the top right hand corner
of Excel it closed all the open workbooks.
I could use the X at the top right hand corner of the actual
worksheet to close cuurent one only.


With 2007 when I use the main X it only closes the current and not all
open worksheets

According to help it is supposed to close all open worksheets the same
as 2003 but this does not happen.


Has anyone got any ideas how to fix this or is it a new " feature"

DJT
.

  #8  
Old December 30th, 2009, 03:15 AM posted to microsoft.public.excel.setup
DJT[_2_]
external usenet poster
 
Posts: 4
Default Closing all worksheets in excel 07

Thanks for that, it was not clear that it had changed

DJT

On Tue, 29 Dec 2009 20:29:33 +0530, "Shailesh Shah"
wrote:

It is a new feature in Excel-2007.
To quit from Excel, double click on big office button on top left corner.

Regards,
Shailesh Shah
http://shahshaileshs.web.officelive.com/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://shahshaileshs.web.officelive.com/MenuAddins.aspx

Free Exshail Classic Menu for Excel-2007
http://shahshaileshs.web.officelive....ssic_Menu.aspx

"DJT" wrote in message
.. .
I have just upgraded from 2003 to 2007 office at the same time as
getting new computer with Windows 7.

I have eventualyl located the commands on the ribbon but I have one
problem

with Excel 2003 when I clicked on the X in the top right hand corner
of Excel it closed all the open workbooks.
I could use the X at the top right hand corner of the actual
worksheet to close cuurent one only.


With 2007 when I use the main X it only closes the current and not all
open worksheets

According to help it is supposed to close all open worksheets the same
as 2003 but this does not happen.


Has anyone got any ideas how to fix this or is it a new " feature"

DJT


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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