Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
in 2007, how come the sort does not default after I save a file?
HI,
I have a spreadsheet, that I occasionally add to, and is sorted. When I add to it, I re-sort, then save. Once I upgraded to 2007, the sort option has to be re done. In older versions, the default sort that I set was saved within the spreadsheet. Apparently, I have to reset the sort again in 2007 every time I add to it. It's annoying because there are several columns to sort. Does anyone know if this is a known problem or have a resolution to this? Thanks, Trina |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
in 2007, how come the sort does not default after I save a file?
I use Excel 2007. It retains the sort criteria when I save and close the
workbook. Upon opening the workbook, the sort criteria are still there. "Trina" wrote in message ... HI, I have a spreadsheet, that I occasionally add to, and is sorted. When I add to it, I re-sort, then save. Once I upgraded to 2007, the sort option has to be re done. In older versions, the default sort that I set was saved within the spreadsheet. Apparently, I have to reset the sort again in 2007 every time I add to it. It's annoying because there are several columns to sort. Does anyone know if this is a known problem or have a resolution to this? Thanks, Trina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel automatically resets default save file format | Excel Discussion (Misc queries) | |||
Default a workbook to save as a xlsm (macro-enabled) in 2007 | Excel Discussion (Misc queries) | |||
How do I set the save default not to include .xls in name of file | Excel Discussion (Misc queries) | |||
default save as file type does not work | Excel Discussion (Misc queries) | |||
"Save As" default is a .txt file | Excel Discussion (Misc queries) |