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?