I have a rather large and complicated .xlsx spreadsheet that is used to manage the periotic replacement of assets in our fleet. I have tied this into numerous external sources with great success, and I would like to identify which assets have additional specifically licensed software associated with them that is contained in another encrypted (for obvious reasons) .xlsx spreadsheet that is constantly being updated by another team.
I can not for the life of me work out how to automatically import the data from this encrypted file providing the password, none of the normal methods seam work and I would like to avoid turning it into a macro enabled file if at all possable. Am I missing something?
Note: Sorry I am unable to post the file as it would take a month to deidentify the data.