I have a join set up between a feature class and an Excel table and everything works great.
When I open a second mxd that has the same join set up between the same feature class and Excel table, the join disappears. When I try to recreate the join, I get this message
Failed to connect to database
General Function failure
External table is not in the expected format.
Is there a work around for this? The table has to stay in Excel format so that other non-GIS users can make updates to it.