Sorting lock

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

I have an old file which sorts one sheet always taking in all available
lines, remembers it has a header and overlooks the very first line before
the header as it is a calculator line and I don't want it included. Now I
don't know how I got it to hold this way. I have a new sheet that I want to
do the same with. It never remembers I want to sort with header row, and
will not ignore a line above the header.

Is there some setting I'm missing?

Thanks,
Kate
 
I can choose that but it undoes next time on the other sheet it remains
checked everytime. What's the difference?

Thanks,
Kate
 
Try formatting the cells in the header row differently - XL might pick it up
then.

Rgds,
Andy
 
It was already formatted differently, but I changed it again. Not help. I
made Freeze pane like other sheet, not help.

How does the file get to be shared. Maybe that's it. How can I unshare it.

Thanks,
Kate
 
Tools -- Share Workbook. Tho' from browsing Google, I can't imagine this
will make any difference to picking up the header row.

Rgds,
Andy
 
I didn't see the two as related, but they were. I unshared and now it
remembers my sort criteria!

Thanks for you help,
Kate :~)
 
they were. I unshared and now it remembers my sort criteria!

I finally found some references to sorting issues i.r.o. shared books, but
nothing like this. Go figure.
Thanks for you help,

If you say so. <bg>

Rgds,
Andy
 
Back
Top