Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I close all excel spreadsheets at one time?

Excel 2007. Clicking the uppermost 'X' used to close down all active
spreadsheets, asking if you wanted to save all or step through each closing
spreadsheets and ask specifically to save each one.

That no longer appears to happen in 2007. Now the uppermost 'X' just closes
the active spreadsheet. In effect, there is no difference between clicking
the uppermost 'X' and clicking the specific spreadhseet's 'X'.

Is there an option I am missing somewhere? It is incredably annoying no
having that master 'shut down' button.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default How can I close all excel spreadsheets at one time?

I got the same observation when I read your question. You can double-click
the Office Button on the upper-left side of the screen to close all
worksheets.
--
Chester C. Coronel
Junior BSIT Student
University of Asia and the Pacific, Philippines
Read the StudentEmpowered Blog!http://msforums.ph/blogs/chestercoronel


"Jim T." wrote:

Excel 2007. Clicking the uppermost 'X' used to close down all active
spreadsheets, asking if you wanted to save all or step through each closing
spreadsheets and ask specifically to save each one.

That no longer appears to happen in 2007. Now the uppermost 'X' just closes
the active spreadsheet. In effect, there is no difference between clicking
the uppermost 'X' and clicking the specific spreadhseet's 'X'.

Is there an option I am missing somewhere? It is incredably annoying no
having that master 'shut down' button.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default How can I close all excel spreadsheets at one time?

Jim,

I don't know specifically about Excel 2007, but holding Shift as you click File gives a
"Close all" item. It doesn't close Excel, though. Try that in 07. And try using Alt-F4.
Ya' never know.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Jim T." <Jim wrote in message
...
Excel 2007. Clicking the uppermost 'X' used to close down all active
spreadsheets, asking if you wanted to save all or step through each closing
spreadsheets and ask specifically to save each one.

That no longer appears to happen in 2007. Now the uppermost 'X' just closes
the active spreadsheet. In effect, there is no difference between clicking
the uppermost 'X' and clicking the specific spreadhseet's 'X'.

Is there an option I am missing somewhere? It is incredably annoying no
having that master 'shut down' button.



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
How do I close multiple Excel '07 workbooks at the same time? KYJ Excel Discussion (Misc queries) 1 April 19th 07 04:34 PM
Book1 requires me to choose save each time i close excel panmusic Excel Discussion (Misc queries) 0 April 6th 07 05:22 AM
Open multiple spreadsheets, but close only one Cheri Excel Discussion (Misc queries) 1 February 2nd 06 01:08 AM
Excel shoud not close all active books when clicking close button technomike Excel Discussion (Misc queries) 0 June 10th 05 05:35 PM
excel - Windows close button (x) should only close active workboo. CoffeeAdict Setting up and Configuration of Excel 3 February 8th 05 04:30 AM


All times are GMT +1. The time now is 04:23 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"