Thanks I will try that. BTW what webpage editing software do you use. Your
pages are clearly illustrated.

Best Regards,
EMoorhead
--
Estandardtime Realty


"Debra Dalgleish" wrote:

If you format the heading row differently than the rest of the table,
e.g. Bold font, it should automatically be detected. Then it will remain
at the top after the sort.

Or, choose DataSort, and specify that a header row is included.

Eleanor M wrote:
Thanks it was the header of the columns wadn't included. BTW how do you sort
without rearranging the header in the sort? It gets sorted with all the data
and that confuses the pivot table refresh.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html