Hi,

I have Excel 2007 but although I have the setting in Excel Properties
to save sheets in Excel workbook, everytime a xls is sent to me in a
previous format, when I "save as" it, it gets saved in the original
format and not the new 2007 one. Of course, I could choose the format
before doing the Save but I generally forget to do so.

Is there a way to force excel to always propose the new format is a
"save/save as" operation, overriding the current (old) format of a
spreadsheet ?

Thanks/Brgds
Joao

Hi JJ

Office buttonSave As
Click on the arrow -- after Save As

In the list right click on the format you want and choose add to QAT

Now you have a button that will do what you want



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JJ" wrote in message ...
Hi,

I have Excel 2007 but although I have the setting in Excel Properties
to save sheets in Excel workbook, everytime a xls is sent to me in a
previous format, when I "save as" it, it gets saved in the original
format and not the new 2007 one. Of course, I could choose the format
before doing the Save but I generally forget to do so.

Is there a way to force excel to always propose the new format is a
"save/save as" operation, overriding the current (old) format of a
spreadsheet ?

Thanks/Brgds
Joao