Advanced Filter Grayed Out???
 

Why would the advanced filter option be grayed out when trying to remove
duplicate records. I have close to 40000 records, but I know there are
duplicates. I am trying to slim down the file to unique records only, but
when I try to select Advanced Filter, it will not let me chose it?

Advanced Filter Grayed Out???
 

Is the workbook "shared"?

--
Jim
"Zack" wrote in message
...
| Why would the advanced filter option be grayed out when trying to remove
| duplicate records. I have close to 40000 records, but I know there are
| duplicates. I am trying to slim down the file to unique records only, but
| when I try to select Advanced Filter, it will not let me chose it?

Advanced Filter Grayed Out???
 

Yes. Is that the hiccup?

"Jim Rech" wrote:

Is the workbook "shared"?

--
Jim
"Zack" wrote in message
...
| Why would the advanced filter option be grayed out when trying to remove
| duplicate records. I have close to 40000 records, but I know there are
| duplicates. I am trying to slim down the file to unique records only, but
| when I try to select Advanced Filter, it will not let me chose it?

Advanced Filter Grayed Out???
 

Hi Zack

Yes this is one of them

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Zack" wrote in message ...
Yes. Is that the hiccup?

"Jim Rech" wrote:

Is the workbook "shared"?

--
Jim
"Zack" wrote in message
...
| Why would the advanced filter option be grayed out when trying to remove
| duplicate records. I have close to 40000 records, but I know there are
| duplicates. I am trying to slim down the file to unique records only, but
| when I try to select Advanced Filter, it will not let me chose it?