Importing a sheet from encrypted .xlsx protected file in Excel 2010.

%3CLINGO-SUB%20id%3D%22lingo-sub-153219%22%20slang%3D%22en-US%22%3EImporting%20a%20sheet%20from%20encrypted%20.xlsx%20protected%20file%20in%20Excel%202010.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153219%22%20slang%3D%22en-US%22%3EI%20have%20a%20rather%20large%20and%20complicated%20.xlsx%20spreadsheet%20that%20is%20used%20to%20manage%20the%20periotic%20replacement%20of%20assets%20in%20our%20fleet.%20I%20have%20tied%20this%20into%20numerous%20external%20sources%20with%20great%20success%2C%20and%20I%20would%20like%20to%20identify%20which%20assets%20have%20additional%20specifically%20licensed%20software%20associated%20with%20them%20that%20is%20contained%20in%20another%20encrypted%20(for%20obvious%20reasons)%20.xlsx%20spreadsheet%20that%20is%20constantly%20being%20updated%20by%20another%20team.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20can%20not%20for%20the%20life%20of%20me%20work%20out%20how%20to%20automatically%20import%20the%20data%20from%20this%20encrypted%20file%20providing%20the%20password%2C%20none%20of%20the%20normal%20methods%20seam%20work%20and%20I%20would%20like%20to%20avoid%20turning%20it%20into%20a%20macro%20enabled%20file%20if%20at%20all%20possable.%20Am%20I%20missing%20something%3F%3CBR%20%2F%3ENote%3A%20Sorry%20I%20am%20unable%20to%20post%20the%20file%20as%20it%20would%20take%20a%20month%20to%20deidentify%20the%20data.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-153219%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153669%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20a%20sheet%20from%20encrypted%20.xlsx%20protected%20file%20in%20Excel%202010.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153669%22%20slang%3D%22en-US%22%3EI%20did%20remove%20the%20password%20to%20setup%20a%20working%20import%20to%20the%20file%20to%20make%20sure%20it%20wasnt%20the%20file%20itself%20that%20was%20the%20issue%20(ie%20file%20made%20with%20a%202007%20file%20converter%20on%20instance%20of%202003%20office%20as%20its%20a%20long%20standing%20practice)%2C%20but%20the%20import%20works%20fine%20soon%20as%20its%20disabled.%3CBR%20%2F%3E%3CBR%20%2F%3EYes%20that%20would%20solve%20the%20issue%20but%20due%20to%20the%20location%20and%20the%20number%20of%20authorised%20people%20accessing%20the%20file%20its%20not%20really%20practical.%20We%20have%20a%20rule%20of%20no%20specific%20permisions%20below%20the%204th%20directory%20deep%20on%20a%20drive%20and%20I%20would%20have%20to%20move%20it%20well%20out%20of%20a%20relevent%20location%20to%20do%20it%20that%20way.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153237%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20a%20sheet%20from%20encrypted%20.xlsx%20protected%20file%20in%20Excel%202010.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153237%22%20slang%3D%22en-US%22%3EI%20would%20remove%20protection%20and%20move%20the%20protected%20file%20to%20a%20location%20where%20only%20designated%20people%20in%20the%20organisation%20have%20access%20to%20because%20the%20only%20other%20way%20to%20solve%20this%20issue%20is%20by%20providing%20the%20password%2C%20either%20through%20entering%20by%20hand%20or%20by%20VBA%20code.%3C%2FLINGO-BODY%3E
New Contributor
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.
2 Replies
I would remove protection and move the protected file to a location where only designated people in the organisation have access to because the only other way to solve this issue is by providing the password, either through entering by hand or by VBA code.
I did remove the password to setup a working import to the file to make sure it wasnt the file itself that was the issue (ie file made with a 2007 file converter on instance of 2003 office as its a long standing practice), but the import works fine soon as its disabled.

Yes that would solve the issue but due to the location and the number of authorised people accessing the file its not really practical. We have a rule of no specific permisions below the 4th directory deep on a drive and I would have to move it well out of a relevent location to do it that way.