I do need it a lot and it is an inconvenience. I was hoping it was something
in the way I had Excel 2003 set up.

"Doug Kanter" wrote:

Does it misbehave this way when opening other file types? For instance, an
..xls file, a .txt file, or a .csv file? If it behaves correctly with the
..xls file, but not with the other two, it may be the result of MS supposedly
making Excel "smarter" in the later version. It's making its best guess as
to what *IT* thinks the file type should be.

Matter of fact, I use Excel 2000 and it does exactly that. If I open a .csv
file, and want to change its name, then Save As retains the original .csv
extension, even though I've specified a default file type. If I was doing
this a lot and it became a real inconvenience, I'd hack together a little
macro to save a few mouse clicks, and attach the macro to a toolbar button.

"gregf" wrote in message
...
Yes I am. Again, the save as default worked fine on Excel97

"Doug Kanter" wrote:


"gregf" wrote in message
...
I have the default save as file type under tools/options/transition set
to
.wk4. Excel Office 2003

I open a text file with a .prn suffix. When I go to "save as" the file
name
is enclosed within double quote marks and the original .prn. The file
type
is Text (Tab delimited.)

In Excel97 this feature worked i.e. the filename dropped the .prn and
the
file type was the default .wk4.

Thanks for any help you can provide.



WK4 is the file extension for Lotus 123 spreadsheets, not Excel. Are you
sharing sheets with a Lotus user?