Forcing Save as in the format of Excel 2007

J

JJ

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
 
R

Ron de Bruin

Hi JJ

Office button>Save 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
 

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