ArcMap-Excel Join Error
Came across a new ArcMap bug today. A staff member was trying to join an Excel 2007 file (.xlsx) to a point shapefile in ArcMap and it did not appear to be working. She only had Office 2003 on her machine so I tried it on my spanking new machine that has 2007 installed. Same result–the fields get appended but they are all blank.
I discovered, however, that when I had the table open, if I switched form showing ALL records to only the selected, Poof!