Solved

Excel list isn't in order when performing File - Open from within Excel

Posted on 2012-03-28
4
185 Views
Last Modified: 2012-04-12
Hello,

I have recently upgraded to Windows 7 and Office 2010.
I have my Excel documents sorted a certain way that I was used to in Xp and Office 2007.
The new Excel extensions have thrown this off.
I have gotten around this in folder view by removing extensions for known file types.
However, when I perform File - Open from within Excel I find that the extensions are back.

Is there anyway to keep the extensions out of this view as well?

Thanks.
0
Comment
Question by:FlynnKeilty
  • 2
4 Comments
 
LVL 5

Accepted Solution

by:
Apothis earned 250 total points
ID: 37778588
If you use the File > Open menu in excel, the default is to show only excel files, so grouping them together has already been done for you, and you can just sort by name.

I don't believe there is a way to take the extensions off there. What is the sort order you are using, and how do you expect the sort order to display the files to you?
0
 
LVL 81

Assisted Solution

by:byundt
byundt earned 250 total points
ID: 37780012
In my computer with Excel 2010 and Windows 7 Professional 64 bit, it doesn't matter whether the extensions are hidden or not. The files in Excel's File browser are alphabetized by file name, and they obey the "Hide extensions of known file types" checkbox in Windows Explorer...Organize...Folder and Search Options...View menu.

If you find they are grouped first by file type and then by file name, try clicking the Name caption at the top of the file names. You may have inadvertently clicked on Type, thereby causing the grouping to be incorrect.
0
 

Author Comment

by:FlynnKeilty
ID: 37839766
Thank you very much for your replies. I have not had a chance to go back to this yet.
0
 

Author Closing Comment

by:FlynnKeilty
ID: 37839829
Thank you. I had originally given the user that answer, to change the view.
You've confirmed that there is no other way. I appreciate it.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now