Saving All Documents when closing XL 2007

F

Freedom Elz

Hi All,

I am upgrading to XL 2007 from 97 and having a problem which sounds
simple but is annoying as hell. I have as many as 150 XL files open
at one time (all linked to one another) and with office 97 I would
exit XL and then be prompted to either save the files one at a time
or "yes to all". The "yes to all" option does not appear when I follow
the saem steps in 2007, is there an option somewhere where I can
enable this or has this feature been dropped?
 
J

Jim Rech

When I have several workbooks open with unsaved changes and then close
Excel, the save prompt for the first workbook includes a "Save All" button,
which seems to work for me.
 

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

XL 2007 Macro Security warning 1
Opening Excel 2007 in Excel 2000 2
XL 2007 SP1, Crashes When Editting Chart Title 4
Excel found unreadable content in filename, but file is OK 2
Copying All Cells in XL 2007 4
XL2K floating toolbars not showing up in XL 2007 ... (?) 3
XL 2007 - grinding down to a halt after many rows - no objects,shapes or pagesetups 4
GetSaveAsFilename X & ActiveWorkbook.SaveAs X 2

Top