sort behavior in shared workbook

[Guest]

I frequently need to re-sort data in a shared workbook. The Data>Sort button
recognizes the header row and remembers the sort order when the workbook is
not being shared but does not recognize the header row when the workbook is
shared. Nothing else has been changed except whether or not the workbook is
shared.

How can I get the wizard to recognize the header row and remember the sort
order when the workbook is shared? It used to do it but apparently I messed
with something.

Thanks

 

[David McRitchie]

Hi Joe,
You could try making the top row bold or different format
from the data, though it doesn't seem to work for me very often.

A simple way would be to record a macro doing your sort and
then put it into a double-click event macro.
http://www.mvps.org/dmcritchie/excel/event.htm
http://www.mvps.org/dmcritchie/excel/sorting.htm#activate