2 Replies Latest reply on Apr 18, 2018 11:15 AM by Lohitha Devireddy

    Using the Union feature with password protected excel workbooks

    Mark Alvarado

      I was curious if there is a way to union password protected excel workbooks?


      Here is my situation:

      I have 16 DC's and each DC has an excel workbook that they enter their transportation data in to.  All excel file are in the same folder and with the same trailing file name.  But I have to password protect each file because there is sensitive data that cannot be seen between DC's.

      So when I union the data only the workbooks that are NOT password protected will show.


      The only thing I can think of is that I am NOT the person who put the passwords on the excel files, my manager is.  If I am the password enabler does that make a difference?


      Thank You,