asked on
default option in word and excel
In word, when you open the program, and click on file/open, the option in the bottom can be set to *.* all filles, and when you exit, it will keep that option the next time you open word.
Excel does not seem to keep that option. It defaults back to all kinds of excel files. Is there any way to keep th option *.* all files in Excel like you can in Word?
Excel does not seem to keep that option. It defaults back to all kinds of excel files. Is there any way to keep th option *.* all files in Excel like you can in Word?
Microsoft OfficeMicrosoft WordMicrosoft Excel
Last Comment
Tracy
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Here is a link to do something close in Excel 2007, but it does not have the *.* (all) option:
http://www.dq.winsila.com/tips-tricks/ms-office-tips/how-to-change-the-default-file-type-for-word-2007-and-excel-2007.html
http://www.dq.winsila.com/tips-tricks/ms-office-tips/how-to-change-the-default-file-type-for-word-2007-and-excel-2007.html
That's for saving. Doesn't affect opening.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
My first post of "It can't be done." is mostly accurate but BrainB's idea (http:#a34156202) to rewrite the open button to run a generic open dialog box is pretty cool and deserves some points.
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
Excel can open other types but is usually more specific.
This may be why it does it that way, but my guess is it's just because Office was written by more people than I have in my hometown over a period of several years and we shouldn't expect it to make sense.