My Filters seem to take to long to complete
 

I have a large spreadsheet but recently when I use my auto filter it takes a
few seconds to complete a filter that used to be almost instantaneous. Any
ideas why? I lent the file to a colleague. Could he have set some setting
that would do this?