Sort keeps reverting to default

[Rowley_Birkin_QC]

Version: v.X
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

Hi,

This seems like a pretty basic problem but I couldn't find an answer anywhere. I have a worksheet which I want to manually sort after each change I make. Problem is that each time I select Data->Sort.... the previous settings I entered (Sort by:....., Then by:....) have been lost and I need to keep re-entering them. Have I messed up my settings somewhere?

Thanks!

 

[CyberTaz]

As long as you cell selector is returned to the range that was previously
sorted I believe the criteria should be retained.

However, I haven't used Office X in years & I'm also not clear on exactly
how your data is arranged. If you can be a bit more descriptive of that as
well as how you're going about your workflow perhaps it would helpful.

Regards |:>)
Bob Jones
MVP Office:Mac

 

[Rowley_Birkin_QC]

Thanks Bob for taking the time to reply. I have spent a while playing around with this problem and have finally managed to fix it by copying my cells to a new worksheet.

I couldn't find anything obviously wrong with the original spreadsheet - hopefully the problem wont reappear.

Thanks again.

 

[celesteb]

Rowley,

Did you ever get an answer to your question? I'm having the same problem (in Excel 2008), and it's driving me crazy to have to redo the sort settings for EVERY SINGLE SORT!

I'd love to hear if you figured it out.

Thanks!

 

[Rowley_Birkin_QC]

Afraid not. I just worked around the problem. I copied my data to a new workbook and that seemed to fix the problem. I also encountered the same problem in Office 2003 for Windows XP so the problem is not restricted to Excel on the Mac. In that case I found that removing all data (which I didn't really need) from the last column caused the problem to disappear??? Quite bizarre.