Home Forums Tech Office and Applications Why Excel 2007 doesn't save … Data -> Sort … settings?

Tagged: , , ,

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #2280
    Udar Gromov
    Keymaster

    I’ve notices that on many occasions, Excel 2007 is loosing Data -> Sort settings that are painstaking created in workbooks. Why?

    #2359
    dFrank
    Participant

    THERE IS a WAY to SAVE A SORT in EXCEL 2007

    It is amazing, but why such a simple question take ages to resolve?

    Why Microsoft didn’t put a huge warning label that SORT ORDER in EXCEL 2007 is now behaves completely different from previous versions.

    For years now, I was under impression that is it just a bug, and nothing can be done about it. Finally, some super-small font on some supper-obscure web site whispers that you only can save sort on a table, but on on a range.

    What the h*** is a table. A table is LIST in previous Excel versions. Never heard of it. But we do not need to know about this. Let’s just go thorgh the steps:

      -01- Select a range of cells just a bunch of columns and convert it to table (Ctrl+T);

      -02- Remove annoying unneeded table formatting (Design –> Table Style –> Clear);

      -03- Remove filters (Data – Filter);

      -04- Apply a sort.

    Next time you are in the file, your sort is finally preserved.

    I am pro-Microsoft. I am using only Microsoft products. But they found a sure way to infuriate their customers.

    Finally, THERE IS a WAY to SAVE A SORT in EXCEL 2007

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.