ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting 2007 data (https://www.excelbanter.com/excel-discussion-misc-queries/202663-sorting-2007-data.html)

vicky

Sorting 2007 data
 
I have a list that I need to sort several times a day. In 2003 I would
create a multi-level sort and then the next time I sorted the sort fields
would appear again in the sort window. Often the same sort is applied again,
but sometimes I would have to change one of the fields. With 2007 each time
I go to the multi-level sort window, it is cleared and I have to re-enter the
values. Can anyone think of a solution that I could use to keep my sort
criteria so it could be used again, or slightly modified?

Bob I

Sorting 2007 data
 
Perhaps something is replacing/wiping the Sort? The multi level sort is
usually saved with the file.

Vicky wrote:

I have a list that I need to sort several times a day. In 2003 I would
create a multi-level sort and then the next time I sorted the sort fields
would appear again in the sort window. Often the same sort is applied again,
but sometimes I would have to change one of the fields. With 2007 each time
I go to the multi-level sort window, it is cleared and I have to re-enter the
values. Can anyone think of a solution that I could use to keep my sort
criteria so it could be used again, or slightly modified?



vicky

Sorting 2007 data
 
Your response prompted me to try somethng. The file I was using was an old
2003 file. When I did save as 2007, it worked fine.



"Bob I" wrote:

Perhaps something is replacing/wiping the Sort? The multi level sort is
usually saved with the file.

Vicky wrote:

I have a list that I need to sort several times a day. In 2003 I would
create a multi-level sort and then the next time I sorted the sort fields
would appear again in the sort window. Often the same sort is applied again,
but sometimes I would have to change one of the fields. With 2007 each time
I go to the multi-level sort window, it is cleared and I have to re-enter the
values. Can anyone think of a solution that I could use to keep my sort
criteria so it could be used again, or slightly modified?




Bob I

Sorting 2007 data
 
Glad to hear you discovered the cause!

Vicky wrote:

Your response prompted me to try somethng. The file I was using was an old
2003 file. When I did save as 2007, it worked fine.



"Bob I" wrote:


Perhaps something is replacing/wiping the Sort? The multi level sort is
usually saved with the file.

Vicky wrote:


I have a list that I need to sort several times a day. In 2003 I would
create a multi-level sort and then the next time I sorted the sort fields
would appear again in the sort window. Often the same sort is applied again,
but sometimes I would have to change one of the fields. With 2007 each time
I go to the multi-level sort window, it is cleared and I have to re-enter the
values. Can anyone think of a solution that I could use to keep my sort
criteria so it could be used again, or slightly modified?






All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com