G
Guest
I (along with my boss) have experienced a problem with filters – in 2000 &
2003. They occasionally stop responding. The buttons to make the drop-down
selection are there, but when you click on them nothing happens. I noticed
that it seems to happen more frequently when there’s a large amount of data
(which is when you need the filter option most). It also seems to occur when
there’s a significant amount of highlighted data. The ‘normal’ fix is to
remove the filters, save the file, exit Excel, and try again. It is a pretty
effective (albeit time-consuming) work-around, but it doesn’t always work.
Can you offer any suggestions?
2003. They occasionally stop responding. The buttons to make the drop-down
selection are there, but when you click on them nothing happens. I noticed
that it seems to happen more frequently when there’s a large amount of data
(which is when you need the filter option most). It also seems to occur when
there’s a significant amount of highlighted data. The ‘normal’ fix is to
remove the filters, save the file, exit Excel, and try again. It is a pretty
effective (albeit time-consuming) work-around, but it doesn’t always work.
Can you offer any suggestions?