I have a password protected Excel, xlsx, document. Is there away of connecting to this in ArcMap 10.0 or ArcMap 10.3? I know the password for it.
A colleague is updating the Excel spreadsheet periodically. I am creating a temporary join in an ArcMap document to some polyline data, in order to display the data. In future as the spreadsheet gets updated I will be able to easily run off new maps.
I'm not looking to convert or import the data into ArcMap as we wish to have just one master copy of the data. This way every time the spreadsheet gets updated, I can just run off new maps without doing any conversion.
The Excel file is password protected so other people cannot change the data at all.
Thanks for reading