Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort not saved across saves/reopens
Hi Kris,
Works fine in my 2007 files. On each sheet it remember the last sort I did. But only the last sort on any one sheet. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Kris" wrote: Okay, I have been using Excel 2007 for about 6 months or so and have run into a really really annoying situation that will cause me to go back to Excel 2003 and most likely Office 2003, for complete compatibility reason. I have a big spreadsheet that was created in Excel 2003. It has about 15-20 tabs and some tabs have sheets that I sort some of the columns by date or name or whatever column I want to sort by that day. In Excel 2003 this is remembered across sessions and in Excel 2007 it is not. I do not use any special symbols or anything that would cause problems. If I save my sort in Excel 2007 it is gone when I reopen it the next time. The strange thing is that if I open the file in Excel 2003, which I have to use sometimes at work, or other places, the sorts are there. So, this tells me that it is an Excel 2007 issue. Any idea what is going on? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort not saved across saves/reopens
I have tried all types of things. The fact the file sorts fine, still, in
Excel 2003, tells me there is something wrong with Excel 2007 and this has been across multiple Office 2007 machines and installs. I have saved the file as an Excel 2007 xlsx file and it is fine. Again this tells me that it is an Excel 2007 issue, not a file issue. I cannot save the file as a 2007 version due to the fact too many people that need to edit it and update the file only can use Excel 2003. "Shane Devenshire" wrote: Hi Kris, Works fine in my 2007 files. On each sheet it remember the last sort I did. But only the last sort on any one sheet. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Kris" wrote: Okay, I have been using Excel 2007 for about 6 months or so and have run into a really really annoying situation that will cause me to go back to Excel 2003 and most likely Office 2003, for complete compatibility reason. I have a big spreadsheet that was created in Excel 2003. It has about 15-20 tabs and some tabs have sheets that I sort some of the columns by date or name or whatever column I want to sort by that day. In Excel 2003 this is remembered across sessions and in Excel 2007 it is not. I do not use any special symbols or anything that would cause problems. If I save my sort in Excel 2007 it is gone when I reopen it the next time. The strange thing is that if I open the file in Excel 2003, which I have to use sometimes at work, or other places, the sorts are there. So, this tells me that it is an Excel 2007 issue. Any idea what is going on? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save as txt saves different tab, why??? | Excel Discussion (Misc queries) | |||
Excel Saves Once only | Excel Discussion (Misc queries) | |||
What happens when Excel 07 saves? | Excel Discussion (Misc queries) | |||
Retrieve a saved Excel document after unwanted saves | Excel Discussion (Misc queries) | |||
counting saves | Excel Discussion (Misc queries) |