Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,091
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel automatically resets default save file format [email protected] Excel Discussion (Misc queries) 1 October 17th 07 06:38 PM
Default a workbook to save as a xlsm (macro-enabled) in 2007 Razzer204 Excel Discussion (Misc queries) 3 March 21st 07 06:10 PM
How do I set the save default not to include .xls in name of file Sue Excel Discussion (Misc queries) 1 September 13th 06 08:52 PM
default save as file type does not work gregf Excel Discussion (Misc queries) 5 February 10th 06 07:50 PM
"Save As" default is a .txt file Chesster Excel Discussion (Misc queries) 1 July 25th 05 03:36 PM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"