Excel 2007 question involving SaveAs to .XLS

K

Kirk Bubul

After years with Office 2000 and 2003, I'm learning Excel 2007. I
want to keep the old .XLS file formats with my spreadsheets, none of
which have anything fancier than a SumProduct here and there.

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?

Thank in advance for any help.
 
G

Gord Dibben

Did you experiment?

If so, what did you discover?

If not, why not?


Gord Dibben MS Excel MVP
 
K

Kirk Bubul

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


Did you experiment?

If so, what did you discover?

If not, why not?
 
G

Gord Dibben

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
 

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

Top