Excel 2007 Sort Order Broken

K

Kevin

In Excel 2003, and for some versions before, if I sorted a selected range
(say B4:Z54) by Col E Asc, Col B Asc, and Col F Asc then Excel would remember
the sort parameters so that if I changed ranges to say B104:Z154 it would
keep those same parameters loaded and I could just simply sort my data
without having to re-enter the sort parameters all over again.

Further - if I changed the range and then hit F4, it would re-execute the
sort for whatever new range that I had selected so that I wouldn't even need
to even bring up the sort dialogue. I hit F4 and Boom! done.

In Excel 2007, every time I change ranges, and even sometimes when I move
away from a range and then come back to an old range, I have to re-enter the
sort parameters every flipin' time. Further, if I hit F4 it resorts THE OLD
SELECTED RANGE - How messed up do you have to be to realize how useless that
is? I mean really - if F4 repeats the last command then what could you
possibly do to your spreadsheet that would - in any way - necessitate
re-doing a sort on the same range?

If someone has a work around for this or knows how to get the sort order
functionality to start working the way it was before I would appreciate it
because at this point I am serious considering dumping 2007 and going back to
2003. The improvements in 2007 are just simply not worth having to find
workarounds for all the problems.
 
B

Bob Buckland ?:-\)

Hi Kevin,

You may want to use the link below to also post in the
MS Office Excel discussion group on this.

==========
In Excel 2003, and for some versions before, if I sorted a selected range
(say B4:Z54) by Col E Asc, Col B Asc, and Col F Asc then Excel would remember
the sort parameters so that if I changed ranges to say B104:Z154 it would
keep those same parameters loaded and I could just simply sort my data
without having to re-enter the sort parameters all over again.

Further - if I changed the range and then hit F4, it would re-execute the
sort for whatever new range that I had selected so that I wouldn't even need
to even bring up the sort dialogue. I hit F4 and Boom! done.

In Excel 2007, every time I change ranges, and even sometimes when I move
away from a range and then come back to an old range, I have to re-enter the
sort parameters every flipin' time. Further, if I hit F4 it resorts THE OLD
SELECTED RANGE - How messed up do you have to be to realize how useless that
is? I mean really - if F4 repeats the last command then what could you
possibly do to your spreadsheet that would - in any way - necessitate
re-doing a sort on the same range?

If someone has a work around for this or knows how to get the sort order
functionality to start working the way it was before I would appreciate it
because at this point I am serious considering dumping 2007 and going back to
2003. The improvements in 2007 are just simply not worth having to find
workarounds for all the problems.>>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
R

Rhonda Rowe

I am having the same problem as Kevin was, and I do NOT find the answer in any of the discussion groups you referenced.

Please help.



Bob Buckland ?:-\) wrote:

Re: Excel 2007 Sort Order Broken
01-Mar-08

Hi Kevin

You may want to use the link below to also post in th
MS Office Excel discussion group on this

=========
In Excel 2003, and for some versions before, if I sorted a selected rang
(say B4:Z54) by Col E Asc, Col B Asc, and Col F Asc then Excel would remembe
the sort parameters so that if I changed ranges to say B104:Z154 it woul
keep those same parameters loaded and I could just simply sort my dat
without having to re-enter the sort parameters all over again

Further - if I changed the range and then hit F4, it would re-execute th
sort for whatever new range that I had selected so that I wouldn't even nee
to even bring up the sort dialogue. I hit F4 and Boom! done

In Excel 2007, every time I change ranges, and even sometimes when I mov
away from a range and then come back to an old range, I have to re-enter th
sort parameters every flipin' time. Further, if I hit F4 it resorts THE OL
SELECTED RANGE - How messed up do you have to be to realize how useless tha
is? I mean really - if F4 repeats the last command then what could yo
possibly do to your spreadsheet that would - in any way - necessitat
re-doing a sort on the same range

If someone has a work around for this or knows how to get the sort orde
functionality to start working the way it was before I would appreciate i
because at this point I am serious considering dumping 2007 and going back t
2003. The improvements in 2007 are just simply not worth having to fin
workarounds for all the problems.>
--
Please let us know if this has helped

Bob Buckland ?:-
MS Office System Products MV

LINK
A. Specific newsgroup/discussion group mentioned in this message
news://msnews.microsoft.com/microsoft.public.exce
or via browser
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.exce

B. MS Office Community discussion/newsgroups via Web Browse
http://microsoft.com/office/community/en-us/default.msp
o
Microsoft hosted newsgroups via Outlook Express/newsreade
news://msnews.microsoft.com

EggHeadCafe - Software Developer Portal of Choice
Run the command or application in the Security context of specified user
http://www.eggheadcafe.com/tutorial...2-cd97ef257c99/run-the-command-or-applic.aspx
 
R

Rhonda Rowe

Did you ever get a satisfactory answer to your question? I am having the same problem.



Kevi wrote:

Excel 2007 Sort Order Broken
01-Mar-08

In Excel 2003, and for some versions before, if I sorted a selected range
(say B4:Z54) by Col E Asc, Col B Asc, and Col F Asc then Excel would remember
the sort parameters so that if I changed ranges to say B104:Z154 it would
keep those same parameters loaded and I could just simply sort my data
without having to re-enter the sort parameters all over again.

Further - if I changed the range and then hit F4, it would re-execute the
sort for whatever new range that I had selected so that I wouldn't even need
to even bring up the sort dialogue. I hit F4 and Boom! done.

In Excel 2007, every time I change ranges, and even sometimes when I move
away from a range and then come back to an old range, I have to re-enter the
sort parameters every flipin' time. Further, if I hit F4 it resorts THE OLD
SELECTED RANGE - How messed up do you have to be to realize how useless that
is? I mean really - if F4 repeats the last command then what could you
possibly do to your spreadsheet that would - in any way - necessitate
re-doing a sort on the same range?

If someone has a work around for this or knows how to get the sort order
functionality to start working the way it was before I would appreciate it
because at this point I am serious considering dumping 2007 and going back to
2003. The improvements in 2007 are just simply not worth having to find
workarounds for all the problems.

EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips & Tricks # 12
http://www.eggheadcafe.com/tutorial...8968-ab20ab99320d/dr-dotnetskys-cool-net.aspx
 
R

Rhonda Rowe

Our company just started using Office 2007. Who else can I ask? Should I post this as a brand new question? This is my first time using your message board. Thank you.



Gordon wrote:

in message 09-Oct-09

The post you are replying to is EIGHTEEN MONTHS OLD...........

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Refreshing ASP.NET Cached Data on a timed basis to avoid delays
http://www.eggheadcafe.com/tutorial...ae-e3c7a26c88a4/refreshing-aspnet--cache.aspx
 

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

Similar Threads

Excel 2007 Sort Order broken 2
Excel 2007 Sort Order not working 1
Excel 2007 sorting problem 0
Cannot sort a table containing text 5
Word 2007 flash screen upside down and Word2007 cannot be used 0
Range headings 0
Dates In Excel 5
Accessibilty - how to open doc with keyboard? 0

Top