We help IT Professionals succeed at work.

default option in word and excel

272 Views
Last Modified: 2012-08-13
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?
Comment
Watch Question

CERTIFIED EXPERT
Awarded 2010
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Awarded 2010
Top Expert 2013

Commented:
MS wants you to use Word to edit html files, txt files, rtf files, etc.
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.

Commented:
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 
CERTIFIED EXPERT
Awarded 2010
Top Expert 2013

Commented:
That's for saving. Doesn't affect opening.
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Awarded 2010
Top Expert 2013

Commented:
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.
TracyVBA Developer
CERTIFIED EXPERT

Commented:
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.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.