It's a one-off command that sorts when you do it (rather like autofilter).
If you wanted to update the sort order continuously, you could do it by
formula or have an event macro running in the background.

Hope this helps.

Pete

"Abdul" wrote in message
...
why sort decending doesn't refresh when data changes?