ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 closing (https://www.excelbanter.com/excel-discussion-misc-queries/169060-excel-2007-closing.html)

Keith

Excel 2007 closing
 
We have recently moved to office 2007 and one thing that the users have
brought to my attention is that if they have several spreadsheets open at the
same time and try to close Excel it forces you to close each one
individually.

Is there a way to get back to the old way of closing all the sheets at once
without having to close them one at a time?

Andy Pope

Excel 2007 closing
 
Hi,

Try holding the shift key when clicking the application close button.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Keith" wrote in message
...
We have recently moved to office 2007 and one thing that the users have
brought to my attention is that if they have several spreadsheets open at
the
same time and try to close Excel it forces you to close each one
individually.

Is there a way to get back to the old way of closing all the sheets at
once
without having to close them one at a time?



Jim Rech[_2_]

Excel 2007 closing
 
This behavior is due to having "Windows in taskbar" selected in Advanced
Options, so unselecting that is a way to remedy this issue.

--
Jim
"Keith" wrote in message
...
| We have recently moved to office 2007 and one thing that the users have
| brought to my attention is that if they have several spreadsheets open at
the
| same time and try to close Excel it forces you to close each one
| individually.
|
| Is there a way to get back to the old way of closing all the sheets at
once
| without having to close them one at a time?




All times are GMT +1. The time now is 11:42 PM.

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