Re: Sort keeps reverting to default

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 work***.

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

Thanks again.

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@xxxxxxxxxxxxxxxx" wrote:

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 work*** 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!


.