View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TommyB TommyB is offline
external usenet poster
 
Posts: 12
Default Auto filter sort ascending not working while sheet protected

I have a sheet with a couple of columns that contain formulas, so I have
protected those columns and left the rest of the sheet open for data entry.
The problem is, now when I try to sort ascending or descending (on a column
containing dates) using the auto filter, it just does not work at all.

Any suggestions?
--
TommyB