When experimenting, it doesn't matter if you mess up a copy of the workbook
inquestion.

To answer your original question.......Excel 2007 appears to remember the
format the file was "saved as" when next you click on "save"


Gord

On Fri, 16 Oct 2009 19:08:18 -0500, Kirk Bubul
wrote:

I'm too old to be daring and don't want to mess up my spreadsheets.
But you have emboldened me.


On Fri, 16 Oct 2009 10:56:23 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

Did you experiment?

If so, what did you discover?

If not, why not?


Gord Dibben MS Excel MVP


On Fri, 16 Oct 2009 10:46:22 -0500, Kirk Bubul
wrote:

Question: When I do a SaveAs after working on an .XLS file, does
Excel 2007 remember that I want an .XLS file in the future or must
every Save be a SaveAS?