Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I save all the flies in the window at one go ?
Dear Sir,
Let say I open 12 files in a window and update all of them simultaneously, after that I need to save all the files to quit this session and to proceed with another session. May I know if it is possible for me to save all the files at one go without exiting Excel ? Currently I click File Exit and click Yes to all at the pop up menu. This is the fastest way I know. The disadvantage of doing this is that I need to relaunch Excel. If I do not wish to save all the files, can I do the same at one go ? Currently I need to close each file oe exit Excel and click "No" at the pop up menu for each file. Thanks Low Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I save all the flies in the window at one go ?
On Wed, 27 Feb 2008 06:08:04 -0800, Mr. Low
wrote: Dear Sir, Let say I open 12 files in a window and update all of them simultaneously, after that I need to save all the files to quit this session and to proceed with another session. May I know if it is possible for me to save all the files at one go without exiting Excel ? Currently I click File Exit and click Yes to all at the pop up menu. This is the fastest way I know. The disadvantage of doing this is that I need to relaunch Excel. If I do not wish to save all the files, can I do the same at one go ? Currently I need to close each file oe exit Excel and click "No" at the pop up menu for each file. Thanks If you hold down <shift when you select the File menu, you will see an option that says "Close All". This will help with regard to not having to relaunch Excel. --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I save all the flies in the window at one go ?
When I have 2 unsaved workbooks open in Excel 2002 and 2003 and click Close
All I get a prompt that includes the option to Save All. When I click it nothing seems to happen. Then I repeat the actions and the workbooks close without a prompt. But my changes _are_ saved. Excel remains open. I don't know why I have to do this twice but it does seem to work. -- Jim "Ron Rosenfeld" wrote in message ... | On Wed, 27 Feb 2008 06:08:04 -0800, Mr. Low | wrote: | | Dear Sir, | | Let say I open 12 files in a window and update all of them simultaneously, | after that I need to save all the files to quit this session and to proceed | with another session. | | May I know if it is possible for me to save all the files at one go without | exiting Excel ? Currently I click File Exit and click Yes to all at the | pop up menu. This is the fastest way I know. The disadvantage of doing this | is that I need to relaunch Excel. | | If I do not wish to save all the files, can I do the same at one go ? | Currently I need to close each file oe exit Excel and click "No" at the pop | up menu for each file. | | Thanks | | If you hold down <shift when you select the File menu, you will see an option | that says "Close All". | | This will help with regard to not having to relaunch Excel. | --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
save changes in Excel window appearing when none have been made? | Excel Discussion (Misc queries) | |||
Excel 2002; how to reduce the size of the save dialogue window? | Excel Discussion (Misc queries) | |||
Excel 2002 - How do I use the "name" header in the watch window? | Excel Discussion (Misc queries) | |||
'SAVE AS' WINDOW ICONS DONT WORK Excel 2000 SP3 | Excel Discussion (Misc queries) |